Re: Oracle Update/Insert LONG - strings from ASP

Tom Karlsson wrote:

> Hello everyone,
>
> I get a "ORA-01460: unimplemented or unreasonable conversion requested"
> error when I try to update my db with strings larger then 32K in a LONG
> datatype field.

32k is the limit of variables in PLSQL.

>
>
> I have made a stored procedure that updates the field, and a ADODB.Command
> object to execute the procedure from ASP. I have also tried doing the
> update in SQL, with a ADODB.Recordset, but then the sql string becomes to
> large? It comes up with this error "ORA-01704: string literal too long".
>

The limit for string literals is even smaller: 4000 char

>
> The server is Oracle 8.x running on NT.
>
> Can anyone help me?
>
> Thanks.
>
> Friendly Regards,
> /TK

You should use one of the DBMS... packages. Perhaps you should even use one of the BLOB types, which offer some more possibilities.

The practical use of longs bigger than 32k is very limited in Oracle.

Willi

wilhelm.stiefelhagen_at_gmx.net Received on Sat Sep 09 2000 - 16:50:25 CDT