ORDS Version ords-25.2.0.165.1520
Database 19.24
When trying to enable authentication on a Autorest enabled object we get a ERROR 555
Whe we examine the logs we see
Examining the code it is running further up in the logs we can see the error is on the below statment
L_OBJECT is decalared as L_OBJECT ORDS_METADATA.USER_ORDS_OBJECTS%ROWTYPE;
When I describe L_OBJECT ORDS_METADATA.USER_ORDS_OBJECTS I get
ID NUMBER
SCHEMA_ID NUMBER
PARSING_SCHEMA VARCHAR2(256)
PARSING_OBJECT VARCHAR2(128)
OBJECT_ALIAS VARCHAR2(255)
TYPE VARCHAR2(30)
STATUS VARCHAR2(30)
AUTO_REST_AUTH VARCHAR2(30)
OPS_ALLOWED NUMBER
TYPE_PATH VARCHAR2(10)
PRE_HOOK VARCHAR2(255)
When I describe ORDS_METADATA.USER_ORDS_ENABLED_OBJECTS I get
ID NOT NULL NUMBER
SCHEMA_ID NOT NULL NUMBER
PARSING_SCHEMA NOT NULL VARCHAR2(128)
PARSING_OBJECT VARCHAR2(255)
OBJECT_ALIAS VARCHAR2(255)
TYPE VARCHAR2(30)
STATUS VARCHAR2(30)
AUTO_REST_AUTH NOT NULL VARCHAR2(30)
OPS_ALLOWED NUMBER
TYPE_PATH VARCHAR2(10)
PRE_HOOK VARCHAR2(255)
CREATED_BY VARCHAR2(255)
CREATED_ON DATE
UPDATED_BY VARCHAR2(255)
UPDATED_ON DATE
Obviously not the same collumns…….. So I know the cause of the issue but this is autogenerated code by ORDS so no idea how to fix it.
Can anyone point me toward a known bug? or give me some advice on how to handle this. So far my searching has turned up blank.