Re: SqlPlus batch
Date: Wed, 13 Jul 2005 14:17:44 +0200
User ciccio wrote:
> 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.
myproc(sysdate - 10, sysdate, 1, x, y); end;
-- NoelReceived on Wed Jul 13 2005 - 14:17:44 CEST