Oracle bind variable input
Hello there... :)
Software/Hardware used:
Oracle Application Express 3.1.2.00.02
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
ASKED:
June 8, 2011 10:51 AM
UPDATED:
June 9, 2011 4:43 PM
Answer Wiki:
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'
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
