Error When Installing ApexLib 0.16b

Help
Elie
2007-01-09
2013-04-22
  • Elie

    Elie - 2007-01-09

    Hello Patrick.

    I am running APEX 2.2.0.00.32 on Windows XP.

    I tried to install your ApexLib 0.16b using option (2) in the HowToInstall.txt document:

      "Installation into the application schema (only works with APEX version 2.2)"

    As per the instructions, I logged in SQL*Plus as the parsing schema for my workspace.

    I got the error:

    View created.

                  , COL.DISPLAY_SEQUENCE
                    *
    ERROR at line 39:
    ORA-00904: "COL"."DISPLAY_SEQUENCE": invalid identifier

    I looked at the code in file ApexLib_views_for_userschema.sql, specifically,
    the code for creating view APEXLIB_V_REPORT_COLUMN and saw that the error
    is coming from the mis-spelling of the column DSIPLAY_SEQUENCE in table
    APEX_APPLICATION_PAGE_RPT_COLS.  You are calling this column DISPLAY_SEQUENCE
    when the table calls it DSIPLAY_SEQUENCE.

    Trouble is I'm not sure if you are making use of this column as DISPLAY_SEQUENCE
    or should I simply re-name the column to what the table actually calls it
    DSIPLAY_SEQUENCE.

    What should I do?

    Thank you.

    Elie Grunhaus
    egrunhau@rochester.rr.com

    PS:  Thanks so much for spending the time and effort in creating/supporting
    your neat library.

     
    • Patrick Wolf

      Patrick Wolf - 2007-01-09

      Hi Elie,

      seems that version 2.2.0.00.32 had some issues with misspellings in APEX views. According to the release notes of 2.2.1.00.04 they have fixed the bug

      5499606 Misspellings In Apex Views Columns And Comments

      Maybe you should get this latest patchset (2.2.1.00.04) for APEX at http://www.oracle.com/technology/products/database/application_express/download.html

      If you can't install this patchset, you have to rename the COL.DISPLAY_SEQUENCE to COL.DSIPLAY_SEQUENCE. It's important that my view has the correct spelling, because it's used in the code.

      BTW, I hope to release a new version tomorrow which has a big new feature...

      Patrick

       

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks