9 Replies Latest reply: Sep 17, 2013 3:25 AM by Asif Muhammad RSS

    Facing Parse Errors after upgrading database from 10g to 11g

    SureshM


      Hi,

       

      We are facing parse errors in the SQL's after upgrading database from 10g to 11g.

       

      Kindly look into below parse errors.

       

      ********************************** Parse Error *****************************************************

       

      Tue Aug 13 14:13:08 2013

      kksSetBindType 16173533-2: parse err=1446 hd=3c73061fb8 flg=100476 cisid=173 sid=173 ciuid=173 uid=173

      PARSE ERROR: ospid=15598, error=1446 for statement:

      SELECT ROWID,ORGANIZATION_CODE,PADDED_CONCATENATED_SEGMENTS,PRIMARY_UOM_CODE,REVISION,SUBINVENTORY_CODE,TOTAL_QOH,NET,RSV,ATP,ORGANIZATION_NAME,ITEM_DESCRIPTION,INVENTORY_ITEM_ID,ORGANIZATION_ID,LOCATOR_ID,LOCATOR_TYPE,ITEM_LOCATOR_CONTROL,ITEM_LOT_CONTROL,ITEM_SERIAL_CONTROL FROM MTL_ONHAND_LOCATOR_V WHERE (INVENTORY_ITEM_ID=:1) and (ORGANIZATION_ID=:2) order by ORGANIZATION_CODE,SUBINVENTORY_CODE,REVISION, organization_code, padded_concatenated_segments

      Tue Aug 13 14:13:10 2013

      kksfbc 16173533: parse err=942 hd=3c387c4028 flg=20 cisid=3266 sid=3266 ciuid=3266 uid=3266

      PARSE ERROR: ospid=29813, error=942 for statement:

      Select feature from toad.toad_restrictions where user_name=USER or user_name in ( select ROLE from sys.session_roles)

      kksfbc 16173533: parse err=942 hd=3c97d83648 flg=20 cisid=3266 sid=3266 ciuid=3266 uid=3266

      PARSE ERROR: ospid=29813, error=942 for statement:

      SELECT password

      FROM SYS.USER$

      WHERE  0=1

      kksfbc 16173533: parse err=6550 hd=35185e4278 flg=20 cisid=3266 sid=3266 ciuid=3266 uid=3266

      ----- PL/SQL Stack -----

      ----- PL/SQL Call Stack -----

        object      line  object

        handle    number  name

      319e277050        30  anonymous block

      319e277050        57  anonymous block

      PARSE ERROR: ospid=29813, error=6550 for statement:

      BEGIN sys.dbms_profiler."146775420110782746251362632012"; END;

      kksfbc 16173533: parse err=942 hd=3c142d8600 flg=20 cisid=3266 sid=3266 ciuid=3266 uid=3266

      ----- PL/SQL Stack -----

      ----- PL/SQL Call Stack -----

        object      line  object

        handle    number  name

      319e277050        67  anonymous block

      PARSE ERROR: ospid=29813, error=942 for statement:

      SELECT 1 FROM plsql_profiler_data WHERE 0 = 1

       

      ***************************************************************************************************************************************************************

       

       

      Please help.

       

       

      Regards

      Suresh