Oracle bind variable input

220 pts.
Tags:
Oracle
Oracle Application Express
Oracle applications
Hello there... :)
I've created a report page (page 1) which shows the products of a shop! I've also created a hidden item on page 1 in order to get the ID of the product when a user presses the link for Product Details or the Basket icon... My problem is that I don't know how to insert the value of the #ID# to the bind variable :p1_selected_product_id!!!
Any ideas???
Peter


Software/Hardware used:
Oracle Application Express 3.1.2.00.02

Answer Wiki

Thanks. We'll let you know when a new response is added.

Not sure but since it’s Oracle I’d guess on of the following:

Select value
Into :p1_selected_product_id
From dual;

If PL/SQL
:p1_selected_product_id := value;

SQL Plus you need to take another action… Here is a sample
var control_day4 varchar2(256)
exec :control_day4 := ’4/6/2011′

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following