Forum Stats

  • 3,816,106 Users
  • 2,259,142 Discussions
  • 7,893,390 Comments

Discussions

Error in ASP page using storedprocedure which contain cursor

Hi All,

I am updating connection string perviously used MSDAOR.1 provider, Now updating ORAOLEDB.ORACLE provider. The ASP page executing storedprocedure which using cursor. Error message is "OraOLEDB error '80040e14'
ORA-06550: PLS-00201: identifier 'CURINVCUR' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored "

remaining PL/SQL query are working fine.

if any boby facing simillar kind of issue. please post your answer.

Thanks in advance,
Ranjith kumar S
This discussion has been closed.