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!

Oracle OLEDB store procedure failed to execute

2952936May 19 2015 — edited May 19 2015

Hi,

When I execute a store procedure in Oracle OLEDB connection, it got error:

ADO Error Code: 0x80040e14 Source: OraOLEDB Description: ORA-06550: line 1, column 8: PLS-00306: wrong number or types of arguments in call to 'PRC_FLOAT' ORA-06550: line 1, column 8: PL/SQL: Statement ignored Native Error: 6550 [Database Vendor Code: 6550 ]': ADO Error Code: 0x80040e14 Source: OraOLEDB Description: ORA-06550: line 1, column 8: PLS-00306: wrong number or types of arguments in call to 'PRC_FLOAT' ORA-06550: line 1, column 8: PL/SQL: Statement ignored Native Error: 6550 [Database Vendor Code: 6550 ]

Then I found a below doc to suggest me set "PLSQLRSet" property to TRUE

https://docs.oracle.com/cd/E51173_01/win.122/e18594/using.htm#OLEDB168

However it also doesn't work, I attached my sample App, could you please help me to check whether my code is correct?

Thanks

Spring

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 16 2015

Added on May 19 2015

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

1 comment

2,050 views