Skip to Main Content
Forums

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!

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.

how to use serveroutput commands in plsql

user6040008Mar 11 2013 — edited Mar 11 2013
Hi,

I have to create spool file inside my procedure how is it possible to use it? Is there any way.
Will dynamic statements will work

E.g CREATE OR REPLACE PROCEDURE SP_PROC1
AS
BEGIN

SET SERVEROUPUT ON;

SPOOL D:\ABCD.LOG;

SET SERVEROUTPUT OFF;
SPOOL OFF;

END;
/

Thanks
This post has been answered by Hoek on Mar 11 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 8 2013
Added on Mar 11 2013
6 comments
389 views