ORA-01460: unimplemented or unreasonable conversion requested blob insert

[Jonand]

Hello,

I am trying to insert an blob into a database . For this I am using c++ and microsoft ODBC driver .

The app works fine with files that have less than 4000 bytes . When i am trying to insert a file that has more than 4000 bytes , meaning 3,9 KB it returns : ORA-01460: unimplemented or unreasonable conversion requested .

The database is oracle 11.2.0 . I have searched the internet for a solution but find none .

How could I solve this problem ?

Thanks.

[Rabbit]

I did a quick google search and found this: "attempting to pass a string to a bind variable value in excess of 4000 bytes can result in an ORA-01460"

It sounds like you're binding your variable using a string instead of a lob.

[Jonand]

Hey ,

Yes I am binding a variable using a string .
In c++ ODBC api there is no lob ,blob ,clob type .

I'm using for binding SQL_C_BINARY and SQL_LONGVARBINARY .

retcode = SQLBindParameter(hstmt,  // hstmt
                                1,                     // ipar
                                SQL_PARAM_INPUT,            // fParamType
                                SQL_C_BINARY,               // fCType
                                SQL_LONGVARBINARY,           // FSqlType
                                lbytes,                  // cbColDef
                                0,                     // ibScale
                                &rgbValue,       // rgbValue
                                0,                     // cbValueMax
                                &cbTextSize);            // pcbValue

I am trying to find a solution .So far no luck .
Any help it would be appreciated .

[Rabbit]

If the API doesn't have a way to bind a lob, clob, or blob, you may want to look for another API. You can't bind a string larger than 4000 in length.