Re: Long datatype?

Phil <phillipet_at_mobilair.qc.ca> wrote in message news:3813141F.33DF3272_at_mobilair.qc.ca...
>
> HI,
>
> I've a table like this :
>
> ID VARCHAR2(20)
> KeyWord VARCHAR2(100)
> Narration LONG
>
>
> A LONG Datatype have a 2 Gigs possibilities, yes?
>
> I'm assigning approximately 200 000 bytes (200 000 * "w" character) and
> when i update or insert this value in the table describe before i've got
> this message :
>
> ORA-01480: trailing null missing from STR bind value
>
>
>
> ORACLE Documentation error have this :
>
> [
>
> ORA-01480: trailing null missing from STR bind value
>
> Cause: A bind variable specified as type SQLT_STR is not terminated with
> an ASCII NULL (0) character.
>
> Action: Check maximum lengths and contents of string bind variables.
>
> ]
>
> I tried to put CHR(0) (in Visual Basic, before the INSERT SQL) to the
> end of text but nothing good!
>
>
> Why???
> What can i do?
>
>
>
> P.S. : The text value of the LONG column is the input of a user in a
> RichTextBox (Visual Basic)

Aha! I think I know! The maximum length of a long datatype in a PL/SQL program is *different* to the maximum length that it can be in a table. In a PL/SQL program, the limit is 32k.

This may be your problem? Received on Mon Oct 25 1999 - 20:58:54 CEST