OCI & DATES & PreparedStatements

From: Antonio Pascual <apa_at_jerez.micro.lucent.com>
Date: Tue, 29 Jun 1999 11:17:57 +0200
Message-ID: <7la343$r01@nntpa.cb.lucent.com>

HI ALL AND GOOD DAY. I have a problem and i don't know if the trouble is with Oracle.

I have a sentence like this:

INSERT INTO OCICTEST ( INT_VALUE, STRING_VALUE, DATE_VALUE ) VALUES ( :INT_VALUE, :STRING_VALUE, TO_DATE( :DATE_FIELD, 'DD MM YYYY' )) When i do the binding to the :DATE_FIELD placeholder, i put, for example, '29 06 1999' in the string to bind.
Allways get the same error:

ORA-01847: day of month must be between 1 and last day of month.

The way i do the binding for the :DATE_FIELD placeholder is the same like with :STRING_VALUE.
In both cases i use a char * for the variable to bind.

regards. Received on Tue Jun 29 1999 - 04:17:57 CDT