Hi, I am using oracle sql developer which is a great help for migration. While migrating a schema, in converted ddl i got the code as follows:
ADD CONSTRAINT <constraint name> CHECK
(
( ENDTIME = utils.dateadd('MINUTE', DURATION, STARTTIME) )
)
ENABLE
when i ran this in oracle connection, i got below error:
Error Report -
SQL Error: ORA-00904:"UTILS". "DATEADD": invalid identifier
00904 00000 - "%s: invalid identifier"
I have already checked this in "utils" from "Emulation" user. Please check it as follows:
FUNCTION DATEADD(P_INTERVAL IN VARCHAR2, P_INTERVAL_VAL IN NUMBER, P_DATE_STR IN VARCHAR2) RETURN TIMESTAMP;
FUNCTION DATEADD(P_INTERVAL IN VARCHAR2, P_INTERVAL_VAL IN NUMBER, P_DATE_EXPR IN DATE) RETURN DATE;
FUNCTION DATEADD(P_INTERVAL IN VARCHAR2, P_INTERVAL_VAL IN NUMBER, P_DATE_EXPR IN TIMESTAMP) RETURN TIMESTAMP;
FUNCTION DATEADD(P_INTERVAL IN VARCHAR2, P_INTERVAL_VAL IN NUMBER, P_DATE_EXPR IN TIMESTAMP WITH TIME ZONE) RETURN TIMESTAMP WITH TIME ZONE;
I need help to fix this error.