Home › Forum › General › Oracle stored procedures in connections › Re: Oracle stored procedures in connections
November 9, 2009 at 9:14 am #4909
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