SQL-02155: Date Time Interval only valid with Dynamic=ANSI



SQL-02155: Date Time Interval only valid with Dynamic=ANSI..

Answer / guest

Cause: An attempt to access the datetime interval code or
precision was encountered when type_code option not set to ANSI

Action: Use precompiler option type_code=ansi to access the
date time interval code or date time interval precision

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

LFI-00106: Path object holds more than one path.

1 Answers  


ORA-02478: merge into base segment would overflow MAXEXTENTS limit

1 Answers  


SQL*Loader-00602: Maximum converted length number of column string is too big for bind array

1 Answers  


RMAN-06521: archived logs required to recover from this backup will expire when this backup expires

1 Answers  


TNS-00306: Connection Manager encountered an invalid/unknown trace level

1 Answers  






TNS-12161: TNS:internal error: partial data received

1 Answers  


ORA-34896: (PPMONTHS00) At least 12 month names must be given. Only number were provided.

1 Answers  


TNS-12527: TNS:listener: all instances are in restricted mode or blocking new connections

1 Answers  


NZE-29026: Decryption failure

1 Answers  


ORA-16107: all log data from primary has been processed

1 Answers  


RMAN-02000: wrong message file version (msg number not found)

1 Answers  


ORA-00956: missing or invalid auditing option

1 Answers  


Categories