This index is not required, as the table already has it:
CREATE UNIQUE INDEX "S4SA_SETTINGS_PK" ON "S4SA_SETTINGS" ("CODE")
Error report -
SQL Error: ORA-00955: name is already used by an existing object
This type:
CREATE OR REPLACE TYPE "JSON_VALUE_ARRAY" force as table of json_value;
/
Needs to be created after:
CREATE OR REPLACE TYPE BODY "JSON_VALUE"
Otherwise you get this error:
CREATE OR REPLACE TYPE "JSON_VALUE" force as object
...
ORA-02306: cannot create a type that already has valid dependent(s)
In s4a_settings_data.sql, the schema name has been hardcoded so needs to be edited if a different schema is used.
In apex_oauth.sql:
This index is not required, as the table already has it:
CREATE UNIQUE INDEX "S4SA_SETTINGS_PK" ON "S4SA_SETTINGS" ("CODE") Error report - SQL Error: ORA-00955: name is already used by an existing object
This type:
CREATE OR REPLACE TYPE "JSON_VALUE_ARRAY" force as table of json_value; /
Needs to be created after:
CREATE OR REPLACE TYPE BODY "JSON_VALUE"
Otherwise you get this error: CREATE OR REPLACE TYPE "JSON_VALUE" force as object ... ORA-02306: cannot create a type that already has valid dependent(s)
In s4a_settings_data.sql, the schema name has been hardcoded so needs to be edited if a different schema is used.