PB 7.0 and Oracle Stored Procedure

[Guest_imported]

Hello,
I have stored procedure like this with 2 input and 1 output parameters,
process_employee(
empid in varchar2,
aid in varchar2,
err out varchar) as
....

and in PB I am declaring the procedure lik this,

DECLARE pe PROCEDURE FOR process_employeeempid,:aid);

execute pe;

This is giving me an error Wrong numer or type arguments

But the same thing work well in PB version 6.5.
I am using Oracle ODBC Driver Version 8.1.7

Please help.....

Thanks

 

[daniel32]

rhymond,

Do you have empid and aid declared as varchar in your pb code ? Because if you have them declared as long or integer you will get the message you typed due to mismatched datatypes. I would check and make sure you have the same datatypes in both pb and your stored procedure.

Dan