Error When Installing ApexLib 0.16b

  • Elie

    Elie - 2007-01-09

    Hello Patrick.

    I am running APEX 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
    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

    What should I do?

    Thank you.

    Elie Grunhaus

    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 had some issues with misspellings in APEX views. According to the release notes of they have fixed the bug

      5499606 Misspellings In Apex Views Columns And Comments

      Maybe you should get this latest patchset ( for APEX at

      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...



Log in to post a comment.

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

Sign up for the SourceForge newsletter:

No, thanks