Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> ?? Help needed calling stored procedure
Hello everyone.
I need some help, I am trying to call an Oracle stored procedure from Delphi but I am having some trouble.
I have a store procedure "sp" in a package "p". I can invoke it
successfully
in SQL Plus 3.3 using
SQL> execute p.sp('1324');
However, when I try the same thing in Delphi (using the TSQL component)
it
gives me an error.
Invalide use of keyword. Token : p.sp('1324') Line number: 1.
When I tried to use the TStoredProc component the name of the stored procedure did not come up in the StoredProcName attribute popup menu.
Any suggestions, ideas would be most welcome.
Please reply by e-mail to
nick_at_intrahealth.co.nz
Thanks in advance
Nick Ivanov
Received on Fri Jul 18 1997 - 00:00:00 CDT