Show output from stored procedure on APEX
37104Sep 3 2008 — edited Sep 4 2008Hi,
I have a stored PL/SQL procedure which will be executed when a SUBMIT button is pressed.
Inside this procedure, it performs a DDL statment and keeps the result of DDL in a variable on every LOOP. The value of this variable will be overwritten by the next execution.
For example.
For i in 1..ULIMIT Loop
execute immediate 'alter var2(i) blah blah...';
result message := 'Running ok';
EXCEPT
WHEN OTHERS THEN
result_message := 'Error';
END LOOP;
I guess I can create a large number of hidden items to store the value of variable from my procedure, but I dont think this is a good idea? Because the value of ULIMIT can be changed. Is there a way I can keep the value of this variable of each loop and display in an APEX report?