3 Replies Latest reply: Jan 7, 2013 7:24 AM by BluShadow RSS

    ORA-01461: can bind a LONG value only for insert into a LONG column

    936666
      Hi,
      I am having a string of about 10000 character with the comma separation.
      I am passing the string to a comma separated function say as fn_split which will in-turn will have the split up of string based on comma separation.
      Each string max can be of length 100 characters.

      I am passing my input to fn_split function and i am inserting it to a table
      say like
      inputstring varchar2 :'some 10000 characters with comma separation of each column length max of 100 characters .........................'

      insert into mytable
      Select * from table(fn_split(inputstring))
      but i'm getting the error as
      mytable is a varchar2 field of about 120

      ORA-01461: can bind a LONG value only for insert into a LONG column

      Thanks!