Ora-01460

vehnetltd · #1 (**permalink**) 01-09-03, 05:34

We have a column that is a "long" and when we try to insert more that 32KB into it the we get error ORA-01460 Unimplemented or Unreasonable conversion requested.

Any idea's

andrewst · #2 (**permalink**) 01-09-03, 06:06

Quote:

Originally posted by vehnetltd
We have a column that is a "long" and when we try to insert more that 32KB into it the we get error ORA-01460 Unimplemented or Unreasonable conversion requested.

Any idea's

You can't insert more than 32KB into a LONG column without using Pro*C, ODBC or OCI. I haven't done that, though.
LONGs are obsolete, really - new databases should use LOBs.

vehnetltd · #3 (**permalink**) 01-09-03, 06:49

Thank Tony for the quick reply!

On other thing is..

We have changed the long to a BLOB and when we try to use .NET and the .Net Oracle provider an error is thrown.

I belive it is because we are doing something wrong. Do you have any ideas on how to use .NET with the .Net Oracle provider to insert more than 32KB into a column??

Thanks

Internet Services

Web Development

Digital Marketing

Consumer Tech