Problem with installation of v2_0_3

[Ian Carpenter]

Hi,

I am using APEX 3 2 1 and trying to install Apexlib v2_0_3.

Using the advice give here: http://www.oracle-and-apex.com/automated-integration-of-apexlib-in-your-application/

I started a new SQL plus session and connected as the user that owns the schema objects that my apex workspace is based on. I then ran the command:

@ApexLib_integrate_into_application.sql

and get the following error:

    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
    With the Partitioning, OLAP and Data Mining options
   
    SQL> @ApexLib_integrate_into_application.sql
    .
    . Enter the ID of the application: (eg. 104)
    .
    Enter value for add_to_application_id: 500
    .
    .
    … add application process ApexLib_getGenericResult
    … add application process ApexLib-Before Computation/Validation
    … add application item APEXLIB_REFERENCE_ID
    … add application item APEXLIB_REFERENCE_TYPE
    … add application item APEXLIB_ROUTINE_TYPE
    … add Page 0
           AND PAGE_ID        = 0
               *
    ERROR at line 8:
    ORA-06550: line 8, column 12:
    PL/SQL: ORA-00904: "PAGE_ID": invalid identifier
    ORA-06550: line 4, column 5:
    PL/SQL: SQL Statement ignored
   
   
    Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 6n
    With the Partitioning, OLAP and Data Mining options
    $

  Any advice you can give would be much appreciated.

Thanks

[Peter Raganitsch]

Hi,

did you install the database part of ApexLib at first?

If yes:
- what are your NLS settings?
-  please open the integrate script in an editor and search for PAGE_ID
- check if found statement is valid, maybe the file was corrupted during copying/download

Peter

[Ian Carpenter]

Hi Peter,

Thanks for the very quick response.

Firstly, no I didn't install the database part of ApexLib first, I thought running this script "ApexLib_integrate_into_application.sql" done it all for me. Have I misunderstood this part?

Secondly the nls settings are:

    SQL> show parameter nls
   
    NAME                                 TYPE        VALUE
    ------------------------ ------- --------------------
    nls_calendar                         string
    nls_comp                             string
    nls_currency                         string
    nls_date_format                      string      FXDD-MON-YYYY
    nls_date_language                    string
    nls_dual_currency                    string
    nls_iso_currency                     string
    nls_language                         string      ENGLISH
    nls_length_semantics                 string      BYTE
    nls_nchar_conv_excp                  string      FALSE
    nls_numeric_characters               string
    nls_sort                             string
    nls_territory                        string      UNITED KINGDOM
    nls_time_format                      string
    nls_time_tz_format                   string
    nls_timestamp_format                 string
    nls_timestamp_tz_format              string
    SQL>

Thirdly, the script is falling over at this point:

    - step 1
    - add page 0 if it doesn't exist already
    PROMPT … add Page 0
    declare
        l_exists number;
    begin
        SELECT COUNT(*)
          INTO l_exists
          FROM APEX_APPLICATION_PAGES
         WHERE APPLICATION_ID = wwv_flow.g_flow_id
           AND PAGE_ID = 0;
    …..

When I describe the table `APEX_APPLICATION_PAGES`

    SQL> desc apex_application_pages;
     Name                                      Null?    Type
     --------------------------- ----- -------------------
     IDENTIFIER                                NOT NULL NUMBER(10)
     AAPPLI_IDENTIFIER                         NOT NULL NUMBER(10)
     APAGE_IDENTIFIER                          NOT NULL NUMBER(10)
     CREATED_DATE                              NOT NULL DATE
     CREATED_BY                                NOT NULL VARCHAR2(50)
     MODIFIED_DATE                                      DATE
     MODIFIED_BY                                        VARCHAR2(50)
   
    SQL>

I can see that columns `APPLICATION_ID, PAGE_ID` are not columns of this table.

Please advise.

[Peter Raganitsch]

Hi,

you have to install the database part of ApexLib at first. The reason why this is split into two scripts is, that you need just one installation of ApexLib you can use in multiple Applications.

Your NLS settings look fine, but it seems that you have a local table or view named APEX_APPLICATION_PAGES. With that you overrule the original View from Apex. Please rename your table to something that won't conflict with APEX tables or views.

brgds,

Peter

[Ian Carpenter]

Hi Peter,

Thanks for the clarification regarding the database installation.

I will try the installation again.

Thanks again for the fast turnaround of information.

Regards

Ian