Skip to Main Content

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!

set serveroutput on

76046Dec 19 2001

Hi,

I tried to put 'Set serveroutput on' into a procedure. But, when
I compiled it, I received the error below. Can anyone tell me
what I am doing wrong?

SQL> ed
Wrote file afiedt.buf

1 CREATE OR REPLACE PROCEDURE P2
2 IS
3 BEGIN
4 SET SERVEROUTPUT ON
5* END;
6 /

Warning: Procedure created with compilation errors.

SQL> sho err
Errors for PROCEDURE P2:

LINE/COL ERROR
-------- --------------------------------------------------------
4/5 PLS-00103: Encountered the symbol "SERVEROUTPUT" when
expecting one of the following:
transaction



Thanks in advance.

Sincerely,
Nikhil Kulkarni
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 16 2002
Added on Dec 19 2001
1 comment
709 views