DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

64bit OraOLEDB failed when calling stored procedure with Ref Cursor

133761Jul 12 2007 — edited Jun 5 2012

Hi everyone,

I used the ADO VB sample provided with the Oracle 10g provider installation.
But I compiled it in 64bit Visual Studio 2005 and ran on Windows 2003 x64 server.
The function call "cmd.Execute" when it is trying to call a stored procedure which has an Out Ref Cursor parameter. The exception is

"PLS-00306: wrong number or types arguments in call"

I already set the property "PLSQLRSet" to true. But it doesn't help.

The same code works if I compiled in 32 bit.
It also works if the stored procedure does not have Ref Cursor parameter.

I am guessing this is a bug in the 64bit Oracle provider. Anyone can confirm this please? or am I missing anything?

Wilson

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 3 2012

Added on Jul 12 2007

#oracle-provider-for-ole-db, #windows-and-net

8 comments

6,382 views