Oracle Hello World: How to handle "wrong number or type of arguments" sent to Stored Proc?

Posts   
 
    
ianvink
User
Posts: 393
Joined: 15-Dec-2006
# Posted on: 21-Oct-2020 18:01:27   

I'm a newbie to Oracle but have to use LLBL to get data from Stored Procedures.

I've used LLBL a lot with Sql Server for years perfectly. LLBL is bloody awesome.

So, what strategies should I follow to figure out why I get this error when I Sync?

Error: 'Stored procedure 'XX_WEB_INVENTORY_PKG.GET_OWNED_INVENTORY' caused an exception during resultset retrieval. 
Its resultsets (if any) probably aren't determined in full: ORA-06550: line 1, column 8:
PLS-00306: wrong number or types of arguments in call to 'GET_OWNED_INVENTORY'
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored'

Is there a way to find out what LLBL is sending and what I can do to change?

ianvink
User
Posts: 393
Joined: 15-Dec-2006
# Posted on: 21-Oct-2020 21:53:01   

Issue is that the procedure is listed twice in Package. I have created a new ticket for how to handle that and will close this one