1 Reply Latest reply on May 20, 2020 6:21 PM by cormaco

    Getting Error PLS-00201 identifier 'DBMS_SODA_ADMIN' must be declared.....

    user3151258

      Hi,

      I'm hoping somebody can point me in the right direction, I can't figure this out at the moment.

       

      Running a dev environment Oracle Database Enterprise 19c Version 19.3.0.0.0 on Redhat Linux 7 enterprise.

      I get error PLS-00201L identifier 'DBMS_SODA_ADMIN' must be declared when calling a package that executes PL/SQL SODA operations from another package, procedure, function, trigger etc.

       

      My user has the role SODA_APP and it can describe the package DBMS_SODA_ADMIN. There is a public synonym called DBMS_SODA_ADMIN owned by XDB.

      I can execute the package with the SODA operations in SQL but when it is executed from a third package/function/trigger it bombs out with the error:

       

      ORA-20001: qp_course.set_course$.others.ORA-20001:

      qp_soda_courses.qp_soda_qll_courses.others.ORA-06550: line 1, column 8:

      PLS-00201: identifier 'DBMS_SODA_ADMIN' must be declared

       

      Has anybody else come across this situation?

       

      Thanks

      Stephen