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

ORA-22880: invalid REF

1 Answers  


ORA-24073: cannot specify RETENTION_TIME on exception queue string.string

1 Answers  


NZE-29014: Maximum fragment length extension is incorrect.

1 Answers  


ORA-02479: error while translating file name for parallel load

1 Answers  


ORA-09876: TASDEF_CLOSE: unable to close ?/dbs/tasdef@.dbf file.

1 Answers  


PCB-00206: Cannot use N quoted literal in PL/SQL when NLS_LOCAL=YES

1 Answers  


IMG-00714: internal error

1 Answers  


NCR-04023: NCRR: Invalid object descriptor

1 Answers  


SQL*Loader-00404: Column string present more than once in string's INTO TABLE block.

1 Answers  


TNS-00552: no valid cipher suites were specified

1 Answers  


DRG-11864: Unknown Access Authentication Scheme

1 Answers  


NCR-04017: NCRR: Unable to find the interface instance handle

1 Answers  


Categories