SODA Collection ORA-30625: method dispatch on NULL SELF argument is disallowed
(Doc ID 3023667.1)
Last updated on MAY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.10.0.0.0 and laterInformation in this document applies to any platform.
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
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
Goal |
Solution |