Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-22991: insufficient space allocated for argument string

1 Answers  


ORA-30767: OID type mismatch

1 Answers  


ORA-32737: Hang analysis aborted due to failed memory allocation

1 Answers  


PCC-02336: host variable expression has invalid type

1 Answers  


ORA-01156: recovery in progress may need access to files

2 Answers  






ORA-07257: spdcr: translation error expanding program name.

2 Answers  


DRG-12001: Please enter username:

1 Answers  


ORA-31058: cannot modify read-only XOBs

1 Answers  


ORA-38711: Corrupt flashback log block header: block string

1 Answers  


PCC-00009: Invalid host variable at column number in line number of file string

1 Answers  


ORA-39953: the range value specified is beyond allowed range

1 Answers  


SQL*Loader-00932: Could not truncate table string.

1 Answers  






Categories