PL/SQL (MOSC)

MOSC Banner

How to get around ORA-01461 : can bind a LONG value only for insert into a LONG column?

edited Jun 11, 2012 9:06PM in PL/SQL (MOSC) 3 commentsAnswered
Hi,

We are trying to do a insert of a big string. Over 4000 chars.

INSERT INTO SYSPDM.PDMIN(RECTYPE,DATA) VALUES ('QA_GEN',REPLACE('Q.(***did not include all data***)_2;;[XXX]','[XXX]',chr(10)))

But we get ORA-01461 : can bind a LONG value only for insert into a LONG column.

How can we insert into a CLOB (col:DATA) a value larger then 4000chars?

Regards

U

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center