My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.