Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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

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

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 6 Jul 2006 09:40:36 -0700
Message-ID: <1152204036.227690.153710@m79g2000cwm.googlegroups.com>

stork wrote:
> Is there any way one can make Oracle spit out which parameters failed
> in PLS-00306?
>
> This error message is crap.

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.  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.

HTH -- Mark D Powell -- Received on Thu Jul 06 2006 - 11:40:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US