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-16572: Data Guard configuration file not found

1 Answers  


LPX-00231: invalid character ~1u ('~2c') found in a Name or Nmtoken

1 Answers  


QSM-01046: complex join back on correlated columns not allowed (string)

1 Answers  


ORA-38959: Failed to update block 0 to new version 10 format

1 Answers  


PCC-02101: Unable to open input file

1 Answers  






ORA-32775: cannot change size attributes of read only tablespace string

1 Answers  


PCC-00076: DISPLAY type must be SIGN LEADING SEPARATE

1 Answers  


PLS-00488: invalid variable declaration: object 'string' must be a type or subtype

1 Answers  


ORA-25140: %s space policy cannot be specified for the string extent management

1 Answers  


ORA-26006: Incorrect bind variable in column string's sql expression - string

1 Answers  


LSX-00221: "~1S" is too short (minimum length is ~2d)

1 Answers  


ORA-27194: skgfdvcmd: sbtcommand returned error

1 Answers  


Categories