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

Home -> Community -> Usenet -> c.d.o.tools -> Re: SqlPlus batch

Re: SqlPlus batch

From: Noel <tbal_at_go2.pll-l>
Date: Wed, 13 Jul 2005 14:17:44 +0200
Message-ID: <db3113$pvt$1@inews.gazeta.pl>


User ciccio wrote:

> Hi,
>
> I have a stored procedure defined as follows:
>
> CREATE OR REPLACE PROCEDURE MYPROC (DATE1 IN DATE,
> DATE2 IN DATE,
> MYINT IN NUMBER,
> MYCODE out integer,
> MYMESSAGE out varchar2)
>
> How can I set up a sqlplus batch, in order to run this procedure???
>

Enclose it in <declare begin end> block.

declare
  x integer;
  y varchar2(2000);
  begin
   myproc(sysdate - 10, sysdate, 1, x, y);   end;
/

-- 
Noel
Received on Wed Jul 13 2005 - 07:17:44 CDT

Original text of this message

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