I work with an ORacle 8.1.7 Oracle database
and the PRO*C 8.1.7
When i open this cursor :
exec sql declare toto cursor for
SELECT aracinr
FROM artuc, artrac, artvl, artul,
( SELECT relpere p1, level l1
FROM ( SELECT relpere, relid
FROM resrel
WHERE TO_DATE(:serdrec,'DD-MM-RR HH24:MI')
between relddeb AND reldfin )
CONNECT BY PRIOR relpere = relid
START WITH relid = :sersite )
WHERE
araseqvl = arlseqvl
AND aracfin = :sercfin
AND araccin = :serccin
AND aracinr = artcinr
AND aracinl = arucinl
AND arasite = P1
AND TO_DATE(:serdrec,'DD-MM-RR HH24:MI') between araddeb
I have an 'ORA-01840: input value not long enough for date format ' error
i verify all my host variable and the initialisation is good
the problem come from the query :
FROM ( SELECT relpere, relid
FROM resrel
WHERE TO_DATE(:serdrec,'DD-MM-RR HH24:MI')
between relddeb AND reldfin )
