Re: Oracle LONG Problem

Did you use stored procedure to do the insert? Because PL/SQL LONG type is only max. 32K in length, while the LONG type in database storage is nearly 2G.

Ben Weber <weber_at_pjm.com> wrote in article <35A3D2C4.2A5E_at_pjm.com>...
> I have a Oracle database table in which there is a LONG variable
> which should be able to store values up to 2^31-1 bytes. However,
> when using embedded SQL to save a string of over 32K, i'm getting the
> following error:
>
> Error Code: 1084
> Text: Ora-01084: invalid argument in OCI call
>
> The same code works fine with values of less than 32K.
>
> Has anyone run into this before? I'm using Oracle V. 7.3 and PB 6.
>
> Thanks,
> Ben Weber
>
Received on Sun Jul 12 1998 - 08:49:28 CEST