1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

ORA-06502: PL/SQL: numeric or value error: associative array shape is not consistent

Discussion in 'Oracle Application Express (APEX)' started by Aj_aaron2002@yahoo.co.uk, Nov 1, 2010.

  1. Aj_aaron2002@yahoo.co.uk

    Aj_aaron2002@yahoo.co.uk Active Member

    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    80
    Hello all,
    I am new to oracle APEX and am installing version4.0.
    My 10g database is version 10.2.0.3.0 and I am using windows vista SP1 OS

    My email is aj_aaron2002@yahoo.co.uk

    After long installation period i got the following error.




    ERROR at line 1:
    ORA-06502: PL/SQL: numeric or value error: associative array shape is not
    consistent with session parameters
    ORA-06512: at "APEX_040000.WWV_FLOW_LANG", line 969
    ORA-06512: at "APEX_040000.WWV_FLOW_API", line 243
    ORA-06512: at line 4

    I checked dba_registry for the status and it says LOADING instead of VALID


    pls help

    cheers
    aj.
     
  2. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    Re: ORA-06502: PL/SQL: numeric or value error: associative array shape is not consist

    Found the following on the Oracle Forums...it may answer your question :

    ----------------------------------------------------------------------

    9930553 - FAILED INSTALLATION ON 10.2.0.3
    Application Express 4.0 cannot be installed on Database version 10.2.0.3 on Linux and potentially other platforms as well. The installation will end with "ORA-06502: PL/SQL: numeric or value error: associative array shape is not consistent with session parameters".
    Solution: Apply the patch for bug 5890966 (related bug) or apply the 10.2.0.3 Patch 6 on Windows Platforms (if on Windows Platforms) or apply the 10.2.0.4 database patch set or upgrade to 11gR1 or later.



    HTH

    CJ