Stoedtler, Mathias wrote:
>
> Hello all,
>
> Can anyone tell me why an insert statement fails when using the TO_DATE
> function and same time inserting into a LONG VARCHAR column in the same
> statement.
>
> Is this a bug or an expected behavior?
It is the expected behaviour if the value of the LONG-column is given as
String_literal like
Insert tab VALUES ('test', TO_DATE(...) )
If you will use JDBC/ODBC or the like and use parameter for the LONG-value
(as usually needed as usually you will not include looooooong LONG-values
by hand) like
insert tab values (:longparam, TO_DATE (...) )
this will work.
Elke
SAP Labs Berlin
>
> Regards,
> Mathias
>
>
> ---- Error -------------------------------
> Auto Commit: On, SQL Mode: Oracle, Isolation Level: Committed
> Integrity constraint violation;-8006 POS(1) Data types must be
> compatible:TEXTFIELD.
> INSERT INTO testTable1 (textfield ,datefield) VALUES
> ('Test',TO_DATE('04/27/2000 12:00:00','MM/DD/YYYY HH24:MI:SS'))
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
