PC Review Forums Newsgroups Microsoft DotNet Microsoft ADO .NET Oracle Stored Procedure Default Parameter problem

Reply

Oracle Stored Procedure Default Parameter problem

 
Thread Tools Rate Thread
Old 13-09-2006, 01:42 AM   #1
dave_93_98@yahoo.com
Guest
 
Posts: n/a
Default Oracle Stored Procedure Default Parameter problem


Hello,
I am receiving the following error when trying to call an Oracle stored
procedure inside of a package - PLS-00306 wrong number or types of
arguments.

This happens for several procedures within the package I am using and
by using DeriveParameters I was able to determine that the first
Default Null parameter in each procedure is not visible. The first
procedure has only one Default Null Parameter, the second has 3. If I
call either of these procedures without creating the first Null
parameter they work fine (the fact that the second procedure does
accept two other Null Default parameters has me perplexed).

I can access these without any problems from sqlplus, any ideas or KB
articles would be greatly appreciated.

Thanks,
Dave

  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off