Re: Oracle stored procedures in connections

Home Forum General Oracle stored procedures in connections Re: Oracle stored procedures in connections

#4909

ijobling
Participant

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