search

wso2 / product-is

Welcome to the WSO2 Identity Server source code! For info on working with the WSO2 Identity Server repository and contributing code, click the link below.
http://wso2.github.io/
Apache License 2.0
748 stars 727 forks source link

Errors while executing identity > uma > oracle.sql Script #6984

Closed ShanikaWickramasinghe closed 4 years ago

ShanikaWickramasinghe commented 4 years ago

Suggested Labels Affected/ IS 5.10.0 M8 Snapshot Type/ Bug Priority/ High Severity / Major

Steps to Reproduce

Source the following Oracle DB Scripts against oracle 12 c
/dbscripts/identity/uma/oracle.sql

Observation

Observed the below ERROR logs while sourcing the above script

table IDN_UMA_RESOURCE created.

Error starting at line 14 in command:
CREATE SEQUENCE IDN_UMA_RESOURCE_SEQ START WITH 1 INCREMENT BY 1 NOCACHE
  /

CREATE OR REPLACE TRIGGER IDN_UMA_RESOURCE_TRIG
BEFORE INSERT
ON IDN_UMA_RESOURCE
REFERENCING NEW AS NEW
FOR EACH ROW
BEGIN
SELECT IDN_UMA_RESOURCE_SEQ.nextval INTO :NEW.ID FROM dual
Error at Command Line:15 Column:3
Error report:
SQL Error: ORA-00933: SQL command not properly ended
00933. 00000 -  "SQL command not properly ended"
*Cause:    
*Action:

Error starting at line 24 in command:
END
Error report:
Unknown Command
index IDX_RID created.
index IDX_USER created.
index IDX_USER_RID created.

Error starting at line 36 in command:
CREATE TABLE IDN_UMA_RESOURCE_META_DATA (
  ID                INTEGER,
  RESOURCE_IDENTITY INTEGER                NOT NULL,
  PROPERTY_KEY      VARCHAR2(40),
  PROPERTY_VALUE    VARCHAR2(255),
  PRIMARY KEY (ID),
  FOREIGN KEY (RESOURCE_IDENTITY) REFERENCES IDN_UMA_RESOURCE (ID) ON DELETE CASCADE
)
  /

CREATE SEQUENCE IDN_UMA_RESOURCE_META_DATA_SEQ START WITH 1 INCREMENT BY 1 NOCACHE

Error at Command Line:44 Column:3
Error report:
SQL Error: ORA-00922: missing or invalid option
00922. 00000 -  "missing or invalid option"
*Cause:    
*Action:

Error starting at line 49 in command:
CREATE OR REPLACE TRIGGER IDN_UMA_RESOURCE_METADATA_TRIG
BEFORE INSERT
ON IDN_UMA_RESOURCE_META_DATA
REFERENCING NEW AS NEW
FOR EACH ROW
BEGIN
SELECT IDN_UMA_RESOURCE_META_DATA_SEQ.nextval INTO :NEW.ID FROM dual;
END;
Error report:
ORA-00942: table or view does not exist
00942. 00000 -  "table or view does not exist"
*Cause:    
*Action:

Error starting at line 59 in command:
CREATE TABLE IDN_UMA_RESOURCE_SCOPE (
  ID                INTEGER,
  RESOURCE_IDENTITY INTEGER                NOT NULL,
  SCOPE_NAME        VARCHAR2(255),
  PRIMARY KEY (ID),
  FOREIGN KEY (RESOURCE_IDENTITY) REFERENCES IDN_UMA_RESOURCE (ID) ON DELETE CASCADE
)
  /

CREATE SEQUENCE IDN_UMA_RESOURCE_SCOPE_SEQ START WITH 1 INCREMENT BY 1 NOCACHE

Error at Command Line:66 Column:3
Error report:
SQL Error: ORA-00922: missing or invalid option
00922. 00000 -  "missing or invalid option"
*Cause:    
*Action:
Error starting at line 71 in command:
CREATE OR REPLACE TRIGGER IDN_UMA_RESOURCE_SCOPE_TRIG
BEFORE INSERT
ON IDN_UMA_RESOURCE_SCOPE
REFERENCING NEW AS NEW
FOR EACH ROW
BEGIN
SELECT IDN_UMA_RESOURCE_SCOPE_SEQ.nextval INTO :NEW.ID FROM dual;
END;
Error report:
ORA-00942: table or view does not exist
00942. 00000 -  "table or view does not exist"
*Cause:    
*Action:

Error starting at line 81 in command:
CREATE INDEX IDX_RS ON IDN_UMA_RESOURCE_SCOPE (SCOPE_NAME)
Error at Command Line:81 Column:24
Error report:
SQL Error: ORA-00942: table or view does not exist
00942. 00000 -  "table or view does not exist"
*Cause:    
*Action:

Error starting at line 84 in command:
CREATE TABLE IDN_UMA_PERMISSION_TICKET (
  ID              INTEGER,
  PT              VARCHAR2(255)           NOT NULL,
  TIME_CREATED    TIMESTAMP              NOT NULL,
  EXPIRY_TIME     TIMESTAMP              NOT NULL,
  TICKET_STATE    VARCHAR2(25) DEFAULT 'ACTIVE',
  TENANT_ID       INTEGER     DEFAULT -1234,
  TOKEN_ID        VARCHAR(255),
  PRIMARY KEY (ID)
)
  /

CREATE SEQUENCE IDN_UMA_PERMISSION_TICKET_SEQ START WITH 1 INCREMENT BY 1 NOCACHE

Error at Command Line:94 Column:3
Error report:
SQL Error: ORA-00922: missing or invalid option
00922. 00000 -  "missing or invalid option"
*Cause:    
*Action:

Error starting at line 99 in command:
CREATE OR REPLACE TRIGGER IDN_UMA_PERMISSION_TICKET_TRIG
BEFORE INSERT
ON IDN_UMA_PERMISSION_TICKET
REFERENCING NEW AS NEW
FOR EACH ROW
BEGIN
SELECT IDN_UMA_PERMISSION_TICKET_SEQ.nextval INTO :NEW.ID FROM dual;
END;
Error report:
ORA-00942: table or view does not exist
00942. 00000 -  "table or view does not exist"
*Cause:    
*Action:

Error starting at line 109 in command:
CREATE INDEX IDX_PT ON IDN_UMA_PERMISSION_TICKET (PT)
Error at Command Line:109 Column:24
Error report:
SQL Error: ORA-00942: table or view does not exist
00942. 00000 -  "table or view does not exist"
*Cause:    
*Action:

Error starting at line 112 in command:
CREATE TABLE IDN_UMA_PT_RESOURCE (
  ID             INTEGER,
  PT_RESOURCE_ID INTEGER                NOT NULL,
  PT_ID          INTEGER                NOT NULL,
  PRIMARY KEY (ID),
  FOREIGN KEY (PT_ID) REFERENCES IDN_UMA_PERMISSION_TICKET (ID) ON DELETE CASCADE,
  FOREIGN KEY (PT_RESOURCE_ID) REFERENCES IDN_UMA_RESOURCE (ID) ON DELETE CASCADE
)
  /

CREATE SEQUENCE IDN_UMA_PT_RESOURCE_SEQ START WITH 1 INCREMENT BY 1 NOCACHE

Error at Command Line:120 Column:3
Error report:
SQL Error: ORA-00922: missing or invalid option
00922. 00000 -  "missing or invalid option"
*Cause:    
*Action:

Error starting at line 125 in command:
CREATE OR REPLACE TRIGGER IDN_UMA_PT_RESOURCE_TRIG
BEFORE INSERT
ON IDN_UMA_PT_RESOURCE
REFERENCING NEW AS NEW
FOR EACH ROW
BEGIN
SELECT IDN_UMA_PT_RESOURCE_SEQ.nextval INTO :NEW.ID FROM dual;
END;
Error report:
ORA-00942: table or view does not exist
00942. 00000 -  "table or view does not exist"
*Cause:    
*Action:

Error starting at line 135 in command:
CREATE TABLE IDN_UMA_PT_RESOURCE_SCOPE (
  ID             INTEGER,
  PT_RESOURCE_ID INTEGER                NOT NULL,
  PT_SCOPE_ID    INTEGER                NOT NULL,
  PRIMARY KEY (ID),
  FOREIGN KEY (PT_RESOURCE_ID) REFERENCES IDN_UMA_PT_RESOURCE (ID) ON DELETE CASCADE,
  FOREIGN KEY (PT_SCOPE_ID) REFERENCES IDN_UMA_RESOURCE_SCOPE (ID) ON DELETE CASCADE
)
  /

CREATE SEQUENCE IDN_UMA_PT_RESOURCE_SCOPE_SEQ START WITH 1 INCREMENT BY 1 NOCACHE

Error at Command Line:143 Column:3
Error report:
SQL Error: ORA-00922: missing or invalid option
00922. 00000 -  "missing or invalid option"
*Cause:    
*Action:

Error starting at line 148 in command:
CREATE OR REPLACE TRIGGER IDN_UMA_PT_RESOURCE_SCOPE_TRIG
BEFORE INSERT
ON IDN_UMA_PT_RESOURCE_SCOPE
REFERENCING NEW AS NEW
FOR EACH ROW
BEGIN
SELECT IDN_UMA_PT_RESOURCE_SCOPE_SEQ.nextval INTO :NEW.ID FROM dual;
END;
Error report:
ORA-00942: table or view does not exist
00942. 00000 -  "table or view does not exist"
*Cause:    
*Action:
janakamarasena commented 4 years ago

Could not reproduce in latest UMA script[1] [1] - https://github.com/wso2-extensions/identity-oauth-uma/blob/v1.1.8/features/org.wso2.carbon.identity.oauth.uma.server.feature/resources/dbscripts/oracle.sql

ShanikaWickramasinghe commented 4 years ago

Needs to Reopen this issue as still observing the below issue against 5.10.0 alpha3

CREATE OR REPLACE TRIGGER IDN_UMA_RESOURCE_TRIG BEFORE INSERT ON IDN_UMA_RESOURCE REFERENCING NEW AS NEW FOR EACH ROW BEGIN SELECT IDN_UMA_RESOURCE_SEQ.nextval INTO :NEW.ID FROM dual Error at Command Line:15 Column:3 Error report: SQL Error: ORA-00933: SQL command not properly ended

  1. 00000 - "SQL command not properly ended" Cause:
    Action:

Error starting at line 24 in command: END Error report: Unknown Command index IDX_RID created. index IDX_USER created. index IDX_USER_RID created.

Error starting at line 36 in command: CREATE TABLE IDN_UMA_RESOURCE_META_DATA ( ID INTEGER, RESOURCE_IDENTITY INTEGER NOT NULL, PROPERTY_KEY VARCHAR2(40), PROPERTY_VALUE VARCHAR2(255), PRIMARY KEY (ID), FOREIGN KEY (RESOURCE_IDENTITY) REFERENCES IDN_UMA_RESOURCE (ID) ON DELETE CASCADE ) /

CREATE SEQUENCE IDN_UMA_RESOURCE_META_DATA_SEQ START WITH 1 INCREMENT BY 1 NOCACHE

Error at Command Line:44 Column:3 Error report: SQL Error: ORA-00922: missing or invalid option

  1. 00000 - "missing or invalid option" Cause:
    Action:

Error starting at line 49 in command: CREATE OR REPLACE TRIGGER IDN_UMA_RESOURCE_METADATA_TRIG BEFORE INSERT ON IDN_UMA_RESOURCE_META_DATA REFERENCING NEW AS NEW FOR EACH ROW BEGIN SELECT IDN_UMA_RESOURCE_META_DATA_SEQ.nextval INTO :NEW.ID FROM dual; END; Error report: ORA-00942: table or view does not exist

  1. 00000 - "table or view does not exist" Cause:
    Action:

Error starting at line 59 in command: CREATE TABLE IDN_UMA_RESOURCE_SCOPE ( ID INTEGER, RESOURCE_IDENTITY INTEGER NOT NULL, SCOPE_NAME VARCHAR2(255), PRIMARY KEY (ID), FOREIGN KEY (RESOURCE_IDENTITY) REFERENCES IDN_UMA_RESOURCE (ID) ON DELETE CASCADE ) /

CREATE SEQUENCE IDN_UMA_RESOURCE_SCOPE_SEQ START WITH 1 INCREMENT BY 1 NOCACHE

Error at Command Line:66 Column:3 Error report: SQL Error: ORA-00922: missing or invalid option

  1. 00000 - "missing or invalid option" Cause:
    Action:

Error starting at line 71 in command: CREATE OR REPLACE TRIGGER IDN_UMA_RESOURCE_SCOPE_TRIG BEFORE INSERT ON IDN_UMA_RESOURCE_SCOPE REFERENCING NEW AS NEW FOR EACH ROW BEGIN SELECT IDN_UMA_RESOURCE_SCOPE_SEQ.nextval INTO :NEW.ID FROM dual; END; Error report: ORA-00942: table or view does not exist

  1. 00000 - "table or view does not exist" Cause:
    Action: Error starting at line 81 in command: CREATE INDEX IDX_RS ON IDN_UMA_RESOURCE_SCOPE (SCOPE_NAME) Error at Command Line:81 Column:24 Error report: SQL Error: ORA-00942: table or view does not exist
  2. 00000 - "table or view does not exist" Cause:
    Action:

Error starting at line 84 in command: CREATE TABLE IDN_UMA_PERMISSION_TICKET ( ID INTEGER, PT VARCHAR2(255) NOT NULL, TIME_CREATED TIMESTAMP NOT NULL, EXPIRY_TIME TIMESTAMP NOT NULL, TICKET_STATE VARCHAR2(25) DEFAULT 'ACTIVE', TENANT_ID INTEGER DEFAULT -1234, TOKEN_ID VARCHAR(255), PRIMARY KEY (ID) ) /

CREATE SEQUENCE IDN_UMA_PERMISSION_TICKET_SEQ START WITH 1 INCREMENT BY 1 NOCACHE

Error at Command Line:94 Column:3 Error report: SQL Error: ORA-00922: missing or invalid option

  1. 00000 - "missing or invalid option" Cause:
    Action:

Error starting at line 99 in command: CREATE OR REPLACE TRIGGER IDN_UMA_PERMISSION_TICKET_TRIG BEFORE INSERT ON IDN_UMA_PERMISSION_TICKET REFERENCING NEW AS NEW FOR EACH ROW BEGIN SELECT IDN_UMA_PERMISSION_TICKET_SEQ.nextval INTO :NEW.ID FROM dual; END; Error report: ORA-00942: table or view does not exist

  1. 00000 - "table or view does not exist" Cause:
    Action:

Error starting at line 109 in command: CREATE INDEX IDX_PT ON IDN_UMA_PERMISSION_TICKET (PT) Error at Command Line:109 Column:24 Error report: SQL Error: ORA-00942: table or view does not exist

  1. 00000 - "table or view does not exist" Cause:
    Action:

Error starting at line 112 in command: CREATE TABLE IDN_UMA_PT_RESOURCE ( ID INTEGER, PT_RESOURCE_ID INTEGER NOT NULL, PT_ID INTEGER NOT NULL, PRIMARY KEY (ID), FOREIGN KEY (PT_ID) REFERENCES IDN_UMA_PERMISSION_TICKET (ID) ON DELETE CASCADE, FOREIGN KEY (PT_RESOURCE_ID) REFERENCES IDN_UMA_RESOURCE (ID) ON DELETE CASCADE ) /

CREATE SEQUENCE IDN_UMA_PT_RESOURCE_SEQ START WITH 1 INCREMENT BY 1 NOCACHE

Error at Command Line:120 Column:3 Error report: SQL Error: ORA-00922: missing or invalid option

  1. 00000 - "missing or invalid option" Cause:
    Action:

Error starting at line 125 in command: CREATE OR REPLACE TRIGGER IDN_UMA_PT_RESOURCE_TRIG BEFORE INSERT ON IDN_UMA_PT_RESOURCE REFERENCING NEW AS NEW FOR EACH ROW BEGIN SELECT IDN_UMA_PT_RESOURCE_SEQ.nextval INTO :NEW.ID FROM dual; END; Error report: ORA-00942: table or view does not exist

  1. 00000 - "table or view does not exist" Cause:
    Action:

Error starting at line 135 in command: CREATE TABLE IDN_UMA_PT_RESOURCE_SCOPE ( ID INTEGER, PT_RESOURCE_ID INTEGER NOT NULL, PT_SCOPE_ID INTEGER NOT NULL, PRIMARY KEY (ID), FOREIGN KEY (PT_RESOURCE_ID) REFERENCES IDN_UMA_PT_RESOURCE (ID) ON DELETE CASCADE, FOREIGN KEY (PT_SCOPE_ID) REFERENCES IDN_UMA_RESOURCE_SCOPE (ID) ON DELETE CASCADE ) /

CREATE SEQUENCE IDN_UMA_PT_RESOURCE_SCOPE_SEQ START WITH 1 INCREMENT BY 1 NOCACHE

Error at Command Line:143 Column:3 Error report: SQL Error: ORA-00922: missing or invalid option

  1. 00000 - "missing or invalid option" Cause:
    Action:

Error starting at line 148 in command: CREATE OR REPLACE TRIGGER IDN_UMA_PT_RESOURCE_SCOPE_TRIG BEFORE INSERT ON IDN_UMA_PT_RESOURCE_SCOPE REFERENCING NEW AS NEW FOR EACH ROW BEGIN SELECT IDN_UMA_PT_RESOURCE_SCOPE_SEQ.nextval INTO :NEW.ID FROM dual; END; Error report: ORA-00942: table or view does not exist

  1. 00000 - "table or view does not exist" Cause:
    Action:
ShanikaWickramasinghe commented 4 years ago

Reopening the issue due to the below error

Still observing the below errors against 5.10.0 alpha3 version- oracle 12c client - sqldeveloper

CREATE OR REPLACE TRIGGER IDN_UMA_RESOURCE_TRIG BEFORE INSERT ON IDN_UMA_RESOURCE REFERENCING NEW AS NEW FOR EACH ROW BEGIN SELECT IDN_UMA_RESOURCE_SEQ.nextval INTO :NEW.ID FROM dual Error at Command Line:15 Column:3 Error report: SQL Error: ORA-00933: SQL command not properly ended

  1. 00000 - "SQL command not properly ended" Cause: Action:

Error starting at line 24 in command: END Error report: Unknown Command index IDX_RID created. index IDX_USER created. index IDX_USER_RID created.

Error starting at line 36 in command: CREATE TABLE IDN_UMA_RESOURCE_META_DATA ( ID INTEGER, RESOURCE_IDENTITY INTEGER NOT NULL, PROPERTY_KEY VARCHAR2(40), PROPERTY_VALUE VARCHAR2(255), PRIMARY KEY (ID), FOREIGN KEY (RESOURCE_IDENTITY) REFERENCES IDN_UMA_RESOURCE (ID) ON DELETE CASCADE ) /

CREATE SEQUENCE IDN_UMA_RESOURCE_META_DATA_SEQ START WITH 1 INCREMENT BY 1 NOCACHE

Error at Command Line:44 Column:3 Error report: SQL Error: ORA-00922: missing or invalid option

  1. 00000 - "missing or invalid option" Cause: Action:

Error starting at line 49 in command: CREATE OR REPLACE TRIGGER IDN_UMA_RESOURCE_METADATA_TRIG BEFORE INSERT ON IDN_UMA_RESOURCE_META_DATA REFERENCING NEW AS NEW FOR EACH ROW BEGIN SELECT IDN_UMA_RESOURCE_META_DATA_SEQ.nextval INTO :NEW.ID FROM dual; END; Error report: ORA-00942: table or view does not exist

  1. 00000 - "table or view does not exist" Cause: Action:

Error starting at line 59 in command: CREATE TABLE IDN_UMA_RESOURCE_SCOPE ( ID INTEGER, RESOURCE_IDENTITY INTEGER NOT NULL, SCOPE_NAME VARCHAR2(255), PRIMARY KEY (ID), FOREIGN KEY (RESOURCE_IDENTITY) REFERENCES IDN_UMA_RESOURCE (ID) ON DELETE CASCADE ) /

CREATE SEQUENCE IDN_UMA_RESOURCE_SCOPE_SEQ START WITH 1 INCREMENT BY 1 NOCACHE

Error at Command Line:66 Column:3 Error report: SQL Error: ORA-00922: missing or invalid option

  1. 00000 - "missing or invalid option" Cause: Action:

Error starting at line 71 in command: CREATE OR REPLACE TRIGGER IDN_UMA_RESOURCE_SCOPE_TRIG BEFORE INSERT ON IDN_UMA_RESOURCE_SCOPE REFERENCING NEW AS NEW FOR EACH ROW BEGIN SELECT IDN_UMA_RESOURCE_SCOPE_SEQ.nextval INTO :NEW.ID FROM dual; END; Error report: ORA-00942: table or view does not exist

  1. 00000 - "table or view does not exist" Cause: Action: Error starting at line 81 in command: CREATE INDEX IDX_RS ON IDN_UMA_RESOURCE_SCOPE (SCOPE_NAME) Error at Command Line:81 Column:24 Error report: SQL Error: ORA-00942: table or view does not exist
  2. 00000 - "table or view does not exist" Cause: Action:

Error starting at line 84 in command: CREATE TABLE IDN_UMA_PERMISSION_TICKET ( ID INTEGER, PT VARCHAR2(255) NOT NULL, TIME_CREATED TIMESTAMP NOT NULL, EXPIRY_TIME TIMESTAMP NOT NULL, TICKET_STATE VARCHAR2(25) DEFAULT 'ACTIVE', TENANT_ID INTEGER DEFAULT -1234, TOKEN_ID VARCHAR(255), PRIMARY KEY (ID) ) /

CREATE SEQUENCE IDN_UMA_PERMISSION_TICKET_SEQ START WITH 1 INCREMENT BY 1 NOCACHE

Error at Command Line:94 Column:3 Error report: SQL Error: ORA-00922: missing or invalid option

  1. 00000 - "missing or invalid option" Cause: Action:

Error starting at line 99 in command: CREATE OR REPLACE TRIGGER IDN_UMA_PERMISSION_TICKET_TRIG BEFORE INSERT ON IDN_UMA_PERMISSION_TICKET REFERENCING NEW AS NEW FOR EACH ROW BEGIN SELECT IDN_UMA_PERMISSION_TICKET_SEQ.nextval INTO :NEW.ID FROM dual; END; Error report: ORA-00942: table or view does not exist

  1. 00000 - "table or view does not exist" Cause: Action:

Error starting at line 109 in command: CREATE INDEX IDX_PT ON IDN_UMA_PERMISSION_TICKET (PT) Error at Command Line:109 Column:24 Error report: SQL Error: ORA-00942: table or view does not exist

  1. 00000 - "table or view does not exist" Cause: Action:

Error starting at line 112 in command: CREATE TABLE IDN_UMA_PT_RESOURCE ( ID INTEGER, PT_RESOURCE_ID INTEGER NOT NULL, PT_ID INTEGER NOT NULL, PRIMARY KEY (ID), FOREIGN KEY (PT_ID) REFERENCES IDN_UMA_PERMISSION_TICKET (ID) ON DELETE CASCADE, FOREIGN KEY (PT_RESOURCE_ID) REFERENCES IDN_UMA_RESOURCE (ID) ON DELETE CASCADE ) /

CREATE SEQUENCE IDN_UMA_PT_RESOURCE_SEQ START WITH 1 INCREMENT BY 1 NOCACHE

Error at Command Line:120 Column:3 Error report: SQL Error: ORA-00922: missing or invalid option

  1. 00000 - "missing or invalid option" Cause: Action:

Error starting at line 125 in command: CREATE OR REPLACE TRIGGER IDN_UMA_PT_RESOURCE_TRIG BEFORE INSERT ON IDN_UMA_PT_RESOURCE REFERENCING NEW AS NEW FOR EACH ROW BEGIN SELECT IDN_UMA_PT_RESOURCE_SEQ.nextval INTO :NEW.ID FROM dual; END; Error report: ORA-00942: table or view does not exist

  1. 00000 - "table or view does not exist" Cause: Action:

Error starting at line 135 in command: CREATE TABLE IDN_UMA_PT_RESOURCE_SCOPE ( ID INTEGER, PT_RESOURCE_ID INTEGER NOT NULL, PT_SCOPE_ID INTEGER NOT NULL, PRIMARY KEY (ID), FOREIGN KEY (PT_RESOURCE_ID) REFERENCES IDN_UMA_PT_RESOURCE (ID) ON DELETE CASCADE, FOREIGN KEY (PT_SCOPE_ID) REFERENCES IDN_UMA_RESOURCE_SCOPE (ID) ON DELETE CASCADE ) /

CREATE SEQUENCE IDN_UMA_PT_RESOURCE_SCOPE_SEQ START WITH 1 INCREMENT BY 1 NOCACHE

Error at Command Line:143 Column:3 Error report: SQL Error: ORA-00922: missing or invalid option

  1. 00000 - "missing or invalid option" Cause: Action:

Error starting at line 148 in command: CREATE OR REPLACE TRIGGER IDN_UMA_PT_RESOURCE_SCOPE_TRIG BEFORE INSERT ON IDN_UMA_PT_RESOURCE_SCOPE REFERENCING NEW AS NEW FOR EACH ROW BEGIN SELECT IDN_UMA_PT_RESOURCE_SCOPE_SEQ.nextval INTO :NEW.ID FROM dual; END; Error report: ORA-00942: table or view does not exist

  1. 00000 - "table or view does not exist" Cause: Action:
madurangasiriwardena commented 4 years ago

@ShanikaWickramasinghe what is the below error?

ShanikaWickramasinghe commented 4 years ago

@madurangasiriwardena updated the comment