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!

OraOLEDB error '80040e14' ORA-06550 PLS-00201: stored procedure with REFCUR

user592040Jun 22 2012 — edited Jun 22 2012

Hi All,

We are replacing MSDAORA with OraOLEDB while upgrading Win 2003 to Win 2008 R2 (Oracle version is 11g). But our classis ASP application, that uses stored procedures with REFCURSOR, throwing the following error.

OraOLEDB error '80040e14'

ORA-06550: line 1, column 47: PLS-00201: identifier 'CUR_RESULTS' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored

/cntsearch/default.asp, line 100

The same ASP code is working fine with MSDAORA & Win 2003.

I really appreciate your help.

Please post your suggestions.

Thanks is advance...

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 20 2012

Added on Jun 22 2012

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

3 comments

5,349 views