Oracle stored procedures and cursors
From: James Haydock <james.haydock_at_agsl.co.uk>
Date: Fri, 8 Jun 2001 16:34:54 +0100
Message-ID: <3b20f12a$0$12242$ed9e5944_at_reading.news.pipex.net>
PL/SQL: Statement ignored
Date: Fri, 8 Jun 2001 16:34:54 +0100
Message-ID: <3b20f12a$0$12242$ed9e5944_at_reading.news.pipex.net>
[Quoted] 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 Received on Fri Jun 08 2001 - 17:34:54 CEST