Re: Which parameter causes 'PLS-00306: wrong number or types of arguments in call'

Home -> Community -> Usenet -> c.d.o.server -> Re: Which parameter causes 'PLS-00306: wrong number or types of arguments in call'

From: stork <tbandrow_at_storkyak.com>
Date: 6 Jul 2006 11:56:12 -0700
Message-ID: <1152212171.971131.4070@m73g2000cwd.googlegroups.com>

Stork replied to:

> This is usually fairly simple to figure out. Just compare the coded
> call to the call definition and look at the actual values being passed.

I had a procedure call with 43 parameters.... don't ask... :-)

> It would be nice if Oracle flagged the parameter position where an
> error was detected but the message is no worse than your average C
> compiler error.

Actually, both GNU C++ and Visual C++ are both pretty good about telling you which parameter is goofed up. Compilers are getting better...although in the case of Oracle this more of a binding problem. Received on Thu Jul 06 2006 - 13:56:12 CDT