Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Error: ORA-00904:"UTILS". "DATEADD": invalid identifier

2902991Mar 12 2015 — edited Mar 17 2015

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.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 14 2015
Added on Mar 12 2015
12 comments
4,594 views