ORA-01801 Error in a Pro/C program

From: Dominique Laberge <dominique.laberge_at_medisolution.com>
Date: 18 May 2001 05:06:36 -0700
Message-ID: <a498c100.0105180406.48b822a5_at_posting.google.com>

(excuse my english..i'm french-canadian ) HI!
  I have a very bizarre problem in my Pro/C program.

Ther is the sequence that give my the ora-01801 problem : DECODE(A.INP_DH_FIN, NULL, NVL(TO_CHAR(A.INP_DH_DESACT,
'YYYYMMDDHH24MISS')

        , TO_CHAR TO_DATE :d_date_to, 'YYYYMMDDHH24MISS' ) + 1,
'YYYYMMDDHH24MISS' )) , DECODE(A.INP_DH_DESACT, NULL,
TO_CHAR(A.INP_DH_FIN, 'YYYYMMDDHH24MISS') , DECODE(SIGN(TRUNC(A.INP_DH_DESACT, 'MI')

• TRUNC(A.INP_DH_FIN, 'MI') ), -1, NVL(TO_CHAR(A.INP_DH_DESACT,
  'YYYYMMDDHH24MISS'),'00000000000000'), NVL(TO_CHAR(A.INP_DH_FIN,
  'YYYYMMDDHH24MISS'),'00000000000000')))),
  

The variable :d_date_to seem to give problem, but the contain of it is ok...
The most bizarre thing is that in Oracle 7.3.1 it doesn't matter but in Oracle 8.1.6, it give me "USCHRGIM: open_curs_interv failed with sqlcode=-1801

• ORA-01801: date format is too long for internal buffer"

Any one have an idea of the way to patch it!??

THANKS A LOT Received on Fri May 18 2001 - 14:06:36 CEST