search

OraOpenSource / oos-utils

Common PL/SQL utility scripts
MIT License
204 stars 73 forks source link

Unable to compile oos_util_apex package body #105

Open IsaacAguirre opened 8 years ago

IsaacAguirre commented 8 years ago

This might be a product of installing oos-utils in a local 12c database(Oracle version 12.1.0.2.0), however the oos_util_apex package body doesn't compile it returns the error: _PL/SQL: ORA-00904: "AWS"."SESSION_LIFE_TIMEOUTON": invalid identifier at line 102.

Checking the description of the view for the installation, that column doesn't exist. desc apex_workspace_sessions Name Null Type

WORKSPACE_ID NOT NULL NUMBER
WORKSPACE_NAME NOT NULL VARCHAR2(255)
WORKSPACE_DISPLAY_NAME VARCHAR2(4000) APEX_SESSION_ID NOT NULL NUMBER
USER_NAME VARCHAR2(255)
SESSION_CREATED DATE
SESSION_TIME_ZONE VARCHAR2(255)
SESSION_LANG VARCHAR2(5)
SESSION_TERRITORY VARCHAR2(255)

Also found that the line 104 and 105 are the same image

martindsouza commented 8 years ago

@IsaacAguirre what version of APEX do you have?

IsaacAguirre commented 8 years ago

@martindsouza 4.2.5.00.08. below the result from running select * from apex_release image

martindsouza commented 7 years ago

Will need to support older versions (4.2.x) of APEX in next release