APEX Troubleshooting

Coding

Oracle APEX/REST

Status

If status is INVALID...

SELECT text

FROM user_source

WHERE name = 'VALIDATE_APEX'

AND INSTR(text,'select user#') > 0;

Ouptut should be similar to...

select user# into l_owner# from sys.user$ where name = 'APEX_040200';

If you get this instead...

select user# into l_owner# from sys.user$ where name = '^3';

then do this to fix...

cd ${APXDIR} # Should be set in .profile

sqlplus / as sysdba

set define '^'

@apexvalidate x x APEX_XXXXXX

(Where APEX_XXXXXX represents the current APEX schema. For example, APEX_040200)

exec validate_apex;

The APEX Workspace Activity log is stored in the database as APEX_WORKSPACE_ACTIVITY_LOG.

Number of columns may vary depending on the APEX version. Most important: