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

Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL how-to procedure

Re: PL/SQL how-to procedure

From: Bob Fazio <fazio_at_danet.com>
Date: 1997/04/02
Message-ID: <01bc3f73$438af3a0$64fa03cf@bobfazio.danetinc.com>#1/1

CG <christian.gregory_at_citicorp.com> wrote in article <333C8093.19A5_at_citicorp.com>...
> ...Can anyone tell me if it is possible to create a procedure
> this select statement will not have an into clause.

You can't do anything but an into clause but the following will do basically the same thing.

declare

You must however use the dbms_output.put_line and get_line if you want to see what was put out.

use the following with sqlplus to see the output.

set serverout on size 1000000 -- the 1000000 can be any number between 2k and 1M

-- 
Bob Fazio
Oracle DBA
Danet, Inc.
fazio_at_danet.com
Received on Wed Apr 02 1997 - 00:00:00 CST

Original text of this message

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