Re: PL/SQL: include 'SET' statements in procedure?

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Mon, 07 Jan 2002 08:42:17 +0000
Message-ID: <3C395F69.E743331@exesolutions.com>

Sorry ... thought of the correct answer after I posted this ... you can use SET TRANSACTION because it is part of the database but SET SERVEROUT is part of SQL*Plus.

Daniel Morgan

"Daniel A. Morgan" wrote:

> Not sure about this one ... nor why you would want to ... but you can certainly use
> SET TRANSACTION.
>
> Daniel A. Morgan
>
> Foggy wrote:
>
> > Hello,
> >
> > is it possible to include SET-statements in a procedure, eg set serveroutput on?
> > I tried something like this:
> >
> > create or replace procedure blabla is
> > begin
> > set serveroutput on;
> > <PL/SQL block>
> > end;
> > /
> >
> > Any help appreciated.
> >
> > Regards,
> >
> > Johan
Received on Mon Jan 07 2002 - 02:42:17 CST