ORA-00604 and ORA-01031 Using APEX Office Print
(Doc ID 2754033.1)
Last updated on FEBRUARY 09, 2023
Applies to:
Oracle Application Express (APEX) - Version 20.1 and laterInformation in this document applies to any platform.
The goal of this document is to explain how to solve the ORA-00604 and ORA-01031 error received when running SQL for APEX Office Print.
Symptoms
When attempting to query APEX_APPLICATION_STATIC_FILES
the following error occurs.
ERROR
-----------------------
ORA-00604: error occurred at recursive SQL level 1
ORA-01031: insufficient privileges
STEPS
-----------------------
Run a statement similar to the following n 19c DB with APEX 20.1:
SELECT
CURSOR (
SELECT SF.FILE_NAME
FROM APEX_APPLICATION_STATIC_FILES SF
WHERE SF.FILE_NAME = '<FILENAME>'
) as "static_file"
from dual
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |