Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL: include 'SET' statements in procedure?

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

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Mon, 07 Jan 2002 08:18:30 +0000
Message-ID: <3C3959D6.614114AD@exesolutions.com>


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:18:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US