My Oracle Support Banner

Moving From Mod_plsql To ORDS, Delete Procedure/Operation gives ORA-00931: missing identifier (Doc ID 2717639.1)

Last updated on SEPTEMBER 16, 2022

Applies to:

Oracle REST Data Services - Version 19.2 and later
Information in this document applies to any platform.

Symptoms

On ORDS 19.2+ version

When attempting to run a mod_plsql procedure that performs a delete action
the following error occurs.

ERROR
-----------------------

In the Front end:


404 Not Found with message: "The procedure named <package>.delete could not be accessed. it may not be declared or the user executing this request may not have been granted execute privilege on the procedure. Check the spelling of the procedure and check that the execute privilege has been granted to the caller]] "

In the Background logs:

SEVERE [<HOST>-<PORT>-exec-5] oracle.dbtools.apex.Procedure.resolveNameNew ORA-00931: missing identifier
ORA-06512: at "SYS.DBMS_UTILITY", line 156
ORA-06512: at line 1

        java.sql.SQLSyntaxErrorException: ORA-00931: missing identifier
ORA-06512: at "SYS.DBMS_UTILITY", line 156
ORA-06512: at line 1


STEPS
-----------------------
The issue can be reproduced at will with the following steps:


1. Run a migrated application from OHS mod_pls with ORDS (Oracle REST Data Services)
2. The application loads and other functions work
3. Try to access the option that should delete a row and get the 404 error



Changes

 Migrating from OHS to ORDS

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.