Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error ORDS_ENABLE

Al ejecutar este script

DECLARE
 PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
   ORDS.ENABLE_SCHEMA(p_enabled => TRUE,
                      p_schema => 'PRUEBA_APEX',
                      p_url_mapping_type => 'BASE_PATH',
                      p_url_mapping_pattern => 'test',
                      p_auto_rest_auth => FALSE);
   commit;
END;
Error que empieza en la línea: 1 del comando :
DECLARE
 PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
   ORDS.ENABLE_SCHEMA(p_enabled => TRUE,
                      p_schema => 'PRUEBA_APEX',
                      p_url_mapping_type => 'BASE_PATH',
                      p_url_mapping_pattern => 'test',
                      p_auto_rest_auth => FALSE);
   commit;
END;
Informe de error -
ORA-01403: No se ha encontrado ningún dato
ORA-06512: en "ORDS_METADATA.ORDS", línea 183
ORA-06512: en línea 4
01403. 00000 -  "no data found"
*Cause:    No data was found from the objects.
*Action:   There was no data from the objects which may be due to end of fetch.

Siempre me aparece el mismo mensaje con cualquier esquema. El usuario que lo está ejecutando tiene el rol de ORDS_ADMINISTRATOR_ROLE.

¿Deberá hacerse solo con sys as sysdba?

Comments
Post Details
Added on Sep 6 2023
1 comment
423 views