What does it take to get a procedure in Oracle to return a result set through the connection? I have a procedure that is successful in Oracle but fails through the connection with the error:
ERROR: Agent SQL error ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'FIND_EMPLOYEE_NONCASE'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
I get this error no matter what I have in the send parameters.
This error would indicate that your stored procedure itself is the problem
I can see by 'googling' your error (PLS-00306: wrong number or types of arguments in call ) a number of similar issues on the web. One I see comments:
While calling procedure which uses type/collection as argument we should use the type declared in the package itself and not locally declared type of similar type.Because separate types defined in PL/SQL are not considered to be the same type, even if they are identical.So when I used varaible of type of package it worked.
If it isn't this, perhaps 'google' the error to see other possible reasons for your problem
