Re: Oracle stored procedures and cursors
From: Default <Daniel.Morgan_at_attws.com>
Date: Fri, 08 Jun 2001 15:10:09 -0700
Message-ID: <3B214D41.1A94C3FE_at_attws.com>
Date: Fri, 08 Jun 2001 15:10:09 -0700
Message-ID: <3B214D41.1A94C3FE_at_attws.com>
James Haydock wrote:
> Can any one help with how to return a recordset from a Oracle Stored
> Procedure that takes more than one input parameter.
>
> We have got this to work with 1 parameter but with more than one we get an
> error
> ORA-06550: line 1, column 7:
> PLS-00306: wrong number or types of arguments in call to 'TEST_PROC2'
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
>
> We are using ADO 2.5 and Oracle 8.1.7.3 We are using an ADO command
> object for this.
>
> Thanks
>
> James Haydock
Use a REFCURSOR.
Daniel A. Morgan Received on Sat Jun 09 2001 - 00:10:09 CEST