SQL & PL/SQL

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!

Displaying message text from a stored procedure.

626512Mar 4 2008 — edited Mar 4 2008

Within my stored procedures I am using DBMS_OUTPUT.PUT_LINE to output messages (error/warning/info/debug) but they are not displayed until the procedure has finnished. There is also the problem in that the amount of storage space for these message is limited (exceeding this limit can cause an OK procedure run to terminate with an error :( ).

Is there a better way that results in the 'displays' being made visible immediately?

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 1 2008

Added on Mar 4 2008

2 comments

759 views