isqlplus, calling stored procedure with cursor
From: <codefragment_at_googlemail.com>
Date: Wed, 20 Feb 2008 02:32:29 -0800 (PST)
Message-ID: <783dee05-0e00-45eb-a486-80f7be37292d@k2g2000hse.googlegroups.com>
Date: Wed, 20 Feb 2008 02:32:29 -0800 (PST)
Message-ID: <783dee05-0e00-45eb-a486-80f7be37292d@k2g2000hse.googlegroups.com>
Hi
I can call any stored procedure in sqlplus via a script using syntax
like this
variable C refcursor;
declare
pARG NUMBER := 18;
begin
myproc(:C, pARG)
end;
/
print C
Although I can upload this script using isqlplus it doesn't work,
possibly because its
expecting something that could be run via 'ed'? How could I get the
equilvilent working in
isqlplus? (message included below)
thanks
declare
*
ERROR at line 1:
ORA-01861: literal does not match format string
ORA-06512: at line 4
ERROR:
ORA-24338: statement handle not executed
SP2-0625: Error printing variable "c"
Received on Wed Feb 20 2008 - 04:32:29 CST