none
Azure deployed ASP app provider issue with oracle db RRS feed

  • Question

  • Hi Team,

    I am migrating ASP with oracle 10 db to azure based window 2012 r2 Vm and oracle on oracle 12c.

    On ASP vm I have installed oracle 11g client.previously app was on 32 bit and now env is on 64 bit.

    Previously the connection string was

    Provider=MSDAORA.1;Data Source=db1;User ID="abcd";Password= " abcd"

    After cloud migration I have changed it to

    Driver={Oracle in OraClient11g_home1}; DBQ=probe32; User ID="ABCD&";Password="abcd";PLSQLRSet=True"

    Now in case of calling stored procedure through asp code

    We are getting below error

    _PLS-00201:_identifier_'abcCURSOR'_must_be_declared_ORA-06550:

    Through asp code we are passing {resultset 0, abcCURSOR})} as refrence out parameter to stored procedure. The same code was working fine in existing enviorment. But after changing the connection string or provider it started throwing error.

    Stored procedure is like this

    CREATE OR REPLACE PACKAGE Aaa.abcGetPkg

    IS

    TYPE dnCursor   is REF CURSOR;

    PROCEDURE Getmydetails (

                                    intId       IN           NUMBER,

                                    strDate IN           VARCHAR2,

                                    abcCURSOR                        OUT       dnCursor);

    Can you please suggest solution to resolve this issue.

    Regards,

    Ashok

     

    Sunday, September 2, 2018 7:23 PM

Answers

All replies