Posted By: joet How To call A Stored Procedure - 03/13/04 02:50 AM
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);
}
Posted By: Marco Kalter Re: How To call A Stored Procedure - 03/16/04 12:43 AM
What exactly is the Oracle error?
Posted By: joet Re: How To call A Stored Procedure - 03/16/04 01:01 AM
ORA-06550: line2: column3: pls-00306 wrong number or types of arguments in call to in call to 'sig_getnextcounterid' ORA-06550 line2: column3:
Posted By: Marco Kalter Re: How To call A Stored Procedure - 03/16/04 11:04 PM
This would indicate that the 'ig_getnextcounterid' function does not have 1 string parameter. Can you let me know its declaration?
© Allround Automations forums