Re: PL/SQL : serveroutput on inside begin..end block Possible ? Impossible??

From: Dmitry E. Loginov <lde_at_mpsb.ru>
Date: Wed, 6 Jul 2005 11:10:14 +0400
Message-ID: <dag026$2d7d$1@news.caravan.ru>

"baka" <mesundara_at_hotmail.com> wrote in message news:1120632470.390863.80300_at_g43g2000cwa.googlegroups.com...
> Dear all

...
> --Sample image of my problem
> -- implementing the serveroutput on inside pl/sql
> SQL> create or replace procedure stest as
...
> 7 execute immediate 'ALTER SYSTEM SET SERVEROUTPUT ON SIZE
> 500K';

...
> 11 DBMS_OUTPUT.PUT_LINE('String Before breaking'||t_astr1);
> execute immediate 'ALTER SYSTEM SET SERVEROUTPUT OFF';
...
> *
> Error in Line 1:
> ORA-02065: ALTER SYSTEM -Option ignored??.
>
> What is the alternate way of writing Line 7:

SET SERVEROUTPUT ... is a SQL*Plus SET command. ALTER SYSTEM nas not SERVEROUTPUT clause.

Just use DBMS_OUTPUT.ENABLE and DBMS_OUTPUT.DISABLE procedures.

RTM:
Supplied PL/SQL Packages and Types Reference DBMS_OUTPUT Dmitry Loginov. Received on Wed Jul 06 2005 - 02:10:14 CDT