SEO

#1 (**permalink**) 02-26-2008, 07:53 AM

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"

#2 (**permalink**) 02-26-2008, 07:53 AM

Sorry, it does work. The problem was that in my real example I passed
a date in in the wrong format, it worked
in sqlplus but not in isqlplus.
Sorry again

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

isqlplus, calling stored procedure with cursor