Precompilers and OCI (MOSC)

MOSC Banner

Different return for Oracle 9i and above when using proc to insert more than one column of Varcahr2(

edited Aug 30, 2014 5:00AM in Precompilers and OCI (MOSC) 3 commentsAnswered

I created a table with 3 VARCHAR2(4000) fileds in Oracle 9i.

create table tbl_varchar(a varchar2(4000), b varchar2(4000), c varchar2(4000));

Then, I used proc code to insert values("abc" is a, "def" is b, "ghi" is c) into this table. It returns error "ORA-01461: can bind a LONG value only for insert into a LONG column". But when I inserted only one value(such as only a field "abc") into the table, It works well.

I just created the same table in Oracle 10g or 11g.

create table tbl_varchar(a varchar2(4000), b varchar2(4000), c varchar2(4000));

I also used proc code to insert 3 fields into the table. It works well.

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