After connecting to Oracle 10g in direct mode, when I insert VARCHAR2(4000) column to some value, occur this error
However, if the column is sent to the back of the insert statement or the value is less than 715 Bytes, the error does not occur.ORA-01461: can bind a LONG value only for insert into a LONG column
Code: Select all
CREATE TABLE TEST (
COL1 VARCHAR2(10 BYTE),
COL2 VARCHAR2(4000 BYTE),
COL3 VARCHAR2(10 BYTE)
)
Code: Select all
INSERT INTO TEST
(
COL1, COL2, COL3
)
VALUES
(
:COL1, :COL2, :COL3
)
Code: Select all
INSERT INTO TEST
(
COL1, COL2, COL3
)
VALUES
(
:COL1, :COL2, 'Value'
)
Thanks advance.
Oracle Server Version
- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options