Return a value from a procedure to apex
macwaduFeb 21 2011 — edited Feb 22 2011Hi
I'm running a procedure that has a return flag if the procedure execute correctly a command i send to him, i do something like this to call the procedure in the apex processes
Declare
x NUMBER;
BEGIN
APEX_SCHEMA.EXECUTE_CREATE_ITEM('asd', x);
DBMS_OUTPUT.PUT_LINE('OUTPUT:'||x);
END;
can i return to the apex the the variable x to show it in success or error message of the process?
Tanks