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

IMP-00033: Warning: Table "string" not found in export file

2 Answers  


ORA-07451: slskstat: unable to obtain load information.

1 Answers  


TNS-00022: INTCTL: missing CMANAGER_NAME in INTCHG.ORA

1 Answers  


ORA-09368: Windows 3.1 Two-Task driver unable to spawn ORACLE

1 Answers  


ORA-14288: index is not partitioned by Composite Range method

1 Answers  


ORA-12674: Shared server: proxy context not saved

1 Answers  


ORA-26535: %ud byte row cache insufficient for table with rowsize=number

1 Answers  


ORA-26662: unable to process STREAMS Data Dictonary information for object

1 Answers  


DRG-13309: operation not supported by USER_LEXER

1 Answers  


ORA-14003: GLOBAL clause contradicts previosly specified LOCAL clause

1 Answers  


ORA-36984: (XSRELGID04) A value cannot be inserted into dimension workspace object.

1 Answers  


ORA-38762: thread string redo log with scn string could not be found

1 Answers  


Categories