Click here to Skip to main content
15,672,517 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:

while developing a windows application in .NET , i am getting below mentioned issue.
ORA-01461: can bind a LONG value only for insert into a LONG column

there is a column in a table where i am trying to save image data in RTF format. I am able to save upto 3 images in this column, but when i add 4th image data , I get this error.

I changed the datatype from varchar2(4000) to CLOB as suggested in ohe of the articles on net.
When i am trying to save with a insert statement it is working fine, is it something to be done with sql statements genrated by Dataset in .NET

Please suggest how i can resolve this error.

Thanks in advance.
Updated 8-Sep-19 18:14pm
navin ks 2-Apr-13 0:17am    
in mysql case i use datatype as LONGBLOB. in your case find suitable datatype
srastogi85 2-Apr-13 0:21am    
I used CLob in Oracle , but it didnt worked
Sudhakar Shinde 9-Apr-13 2:32am    
You are getting ORA-01461 when datatype is varcha2(4000) or CLOB?

1 solution

OraCmd.Parameters.Add(ParamName,OracleDbType.Clob).Value = ParamValue;
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900