Print Thread
How To call A Stored Procedure
#6180 03/13/04 02:50 AM
Joined: Feb 2004
Posts: 15
J
joet Offline OP
Member
OP Offline
Member
J
Joined: Feb 2004
Posts: 15
Im trying to call a stored procedure. I have looked at the FAQ and as far as I can tell this should work. But it doesnt. My Procedure accepts one string, and returns one string. When I try to execute this code i get an oracle error. What am i doing incorrectly?


{
AnsiString Result;
Variant params[] = {"app_feature_id"};
Result = OraclePackage1->CallStringFunction("sig_getnextcounterid", EXISTINGARRAY(params));
ShowMessage(Result);
}

Re: How To call A Stored Procedure
#6181 03/16/04 12:43 AM
Joined: Aug 1999
Posts: 22,206
Member
Offline
Member
Joined: Aug 1999
Posts: 22,206
What exactly is the Oracle error?


Marco Kalter
Allround Automations
Re: How To call A Stored Procedure
#6182 03/16/04 01:01 AM
Joined: Feb 2004
Posts: 15
J
joet Offline OP
Member
OP Offline
Member
J
Joined: Feb 2004
Posts: 15
ORA-06550: line2: column3: pls-00306 wrong number or types of arguments in call to in call to 'sig_getnextcounterid' ORA-06550 line2: column3:

Re: How To call A Stored Procedure
#6183 03/16/04 11:04 PM
Joined: Aug 1999
Posts: 22,206
Member
Offline
Member
Joined: Aug 1999
Posts: 22,206
This would indicate that the 'ig_getnextcounterid' function does not have 1 string parameter. Can you let me know its declaration?


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.083s Queries: 13 (0.027s) Memory: 2.5048 MB (Peak: 3.0393 MB) Data Comp: Off Server Time: 2024-04-28 21:45:50 UTC
Valid HTML 5 and Valid CSS