DBMS_SODA not working PLS-00201: identifier 'DBMS_SODA_ADMIN' must be declared
(Doc ID 3059224.1)
Last updated on DECEMBER 12, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.25.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Testing SODA documents getting
PLS-00201: identifier 'DBMS_SODA_ADMIN' must be declared
The schema in question as been granted SODA_APP.
Tested out the following PLSQL in SQL Developer
DECLARE
collection SODA_COLLECTION_T;
BEGIN
-- Create a collection.
collection := DBMS_SODA.create_collection('myCollectionName');
END;
Error report -
ORA-06550: line 1, column 8:
PLS-00201: identifier 'DBMS_SODA_ADMIN' must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_SODA", line 4
ORA-06512: at line 7
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 |
Cause |
Solution |