How To call A Stored Procedure

joet

Member²
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);
}
 
ORA-06550: line2: column3: pls-00306 wrong number or types of arguments in call to in call to 'sig_getnextcounterid' ORA-06550 line2: column3:
 
This would indicate that the 'ig_getnextcounterid' function does not have 1 string parameter. Can you let me know its declaration?
 
Back
Top