SODA Collection ORA-30625: method dispatch on NULL SELF argument is disallowed (Doc ID 3023667.1)

Last updated on MAY 20, 2024

Applies to:

Goal

We are trying to create the following collection

COLLECTION SCRIPT:

DECLARE
    collection SODA_COLLECTION_T;
    metadata VARCHAR2(4000) :=
     '{
"keyColumn" :
  {
    "name" : "ID",
    "sqlType" : "VARCHAR2",
    "maxLength" : 255,
    "assignmentMethod" : "CLIENT"
  },
    "contentColumn" :
  {
    "name" : "JSON_DOCUMENT",
    "sqlType" : "BLOB",
    "compress" : "NONE",
    "cache" : true,
    "encrypt" : "NONE",
    "validation" : "STANDARD"
  },  
  "creationTimeColumn" :
  {
    "name" : "CREATED_ON"
  },
  "lastModifiedColumn" :
  {
    "name" : "LAST_MODIFIED"
  },
  "readOnly" : FALSE
}';
begin
collection:=DBMS_SODA.create_collection('COL1',metadata);
end;
/

It is behaving like collection and we can access the same collection with SODA queries.

But creating  the same collection from different FID using sqlplus it is not allowing us to create as a SODA collection other than it is creating a normal SQL table,
Getting below error if we trying to  access that table using SODA queries.
O/P:
Error report -
ORA-30625: method dispatch on NULL SELF argument is disallowed
ORA-06512: at line 14
30625. 00000 -  "method dispatch on NULL SELF argument is disallowed"
*Cause:    A member method of a type is being invoked with a NULL SELF
           argument.
*Action:   Change the method invocation to pass in a valid self argument.
 

Granted SODA_APP role privilege to our FID,  it is not creating a SODA collection

Solution

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