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?
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'))
