This content has been marked as final. Show 5 replies
You indicate this is happening on submit. Is the page cache getting cleared on submit? If so, you could store the OUT parameters to Application items rather than Page items.1 person found this helpful
If that's not it, try the following test to eliminate the passed SQL from the potential problems:
create or replace procedure calcola_record_dinamico(statement in varchar2,n_record out number, tot_val out number, tot_qua out number, tot_qau out number) is begin --execute immediate statement into n_record, tot_val, tot_qua, tot_qau; n_record := 1; tot_val := 2; tot_qua := 3; tot_qau := 4; end;
Ok, I will try as soon as possible
Hi. I have tried your example, but nothing seems to happen.
I press the button but my items still remain unassigned.
What can I do?
Thanks for your collaboration,
I will recommend that you run your page in Debug mode and then check the Debug report. Inspect whether
a. The page process that calls the procedure actually executes
b. Where and how the session state values of the OUT parameter Page Items are changing.
Ok, I will try.