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

Do NOT follow this link or you will be banned from the site!