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!

Can't run any actions from Database Actions

phartenfellerJan 31 2024

I have installed ORDS 23.4.0.r3461619 on Oracle Database 23c Free Release 23.0.0.0.0 both via Docker containers. I have REST-enabled a schema and logged into database actions for that schema. Navigating around the UI works fine, but anytime I want to run anything (query, REST enable object, add privilege), I run into errors.

Error log when trying to run a query:

Image

Example REST enabling object:

When I run these actions from PL/SQL everything works fine:

begin

  ORDS_ADMIN.ENABLE_OBJECT(
   p_enabled         => TRUE,
   p_schema          => 'MOVIES',
   p_object          => 'MOVIE_DETAILS_PAGE_JDV',
   p_object_type     => 'VIEW');
   
  commit;
end;
/

I see that it worked in database actions and I can also acess the data.

I'm having trouble identifying the issue, as the error messages are not specific. Can I look into any logs to find out more?

Thanks,

Philipp

Comments
Post Details
Added on Jan 31 2024
8 comments
506 views