Passing variable from a APEX form to PL/SQL Open link in a new borwserwin
527124Mar 11 2011 — edited Mar 14 2011Hello Everyone,
I got a apex form based on a query like :
"INTERFACE_NAME",
"INTERFACE_NAME" INTERFACE_NAME_DISPLAY,
"PRIORITY",
"HAS_STARTED",
"EMAIL_TO",
"STATE",
from "#OWNER#"."INTERFACES"
where "INTERFACE_NAME" = :P2_INTERFACE
only the field state is updateble.
It's just allowd to update the data in the DB-table with a PL/SQL Procedure:
begin
set_interface_vals@DB (p_interface_name => :INTERFACE_NAME, p_state => :STATE);
end;
I did put the prodzedure in a Page Process which act with a submit button.
Now to my problem: how do I get the values of my fields INTERFACE_NAME and STATE. the way I done it here does not work.
Thanks for you help.
regards sia
Edited by: sia on Mar 14, 2011 5:46 PM