Re: SqlPlus batch
From: Noel <tbal_at_go2.pll-l>
Date: Wed, 13 Jul 2005 14:17:44 +0200
Message-ID: <db3113$pvt$1_at_inews.gazeta.pl>
Date: Wed, 13 Jul 2005 14:17:44 +0200
Message-ID: <db3113$pvt$1_at_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???
>
[Quoted] Enclose it in <declare begin end> block.
declare
x integer;
y varchar2(2000);
begin
myproc(sysdate - 10, sysdate, 1, x, y);
end;
/
-- NoelReceived on Wed Jul 13 2005 - 14:17:44 CEST