Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> ?? Help needed calling stored procedure

?? Help needed calling stored procedure

From: Nick Ivanov <nick_at_intrahealth.co.nz>
Date: 1997/07/18
Message-ID: <33CE9706.25585F64@intrahealth.co.nz>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US