APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

DBMS_OUTPUT & set serveroutput on

656867Nov 25 2008 — edited Nov 25 2008

Hello:

In my APEX app I am executing a procedure. Within this procedure I have DBMS_OUTPUT.PUT_LINE displaying results after each function.

In order to see the output which is produced by DBMS_OUTPUT, I have to type, set serveroutput on. When I run my procedure in SQL Developer, I see all the results.

When I run my APEX app with this procedure, I am not able to see the results of the DBMS_OUTPUT. It is important that the user see the results after they submit the parameter for the procedure.

Is there a way that I can display the results of DBMS_OUTPUT after my user clicks the SUBMIT button?

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 23 2008

Added on Nov 25 2008

#apex-discussions

11 comments

1,974 views