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:
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
What should I do?
PS: Thanks so much for spending the time and effort in creating/supporting
your neat library.
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...
Log in to post a comment.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.