Re: ora-6502 - can't append string

No, the data length is less than 80 bytes. Anyway, I've increased it to 200 but still have the same problem.
Please help.

Jim wrote in message ...
>6502 can happen when you are trying to fit 81 char into to 80 char field.
>
>Try using a larger number than 80, just for testing try 200 or maybe try
>using message to find out what the lenght of your
>ws_keys || index_name is
>
>message(length(ws_keys || index_name));
>
>Good luck
>
>
>Lai <lyekheng_at_hotmail.com> wrote in message
>news:3739095c.0_at_news.cyberway.com.sg...
>> Hi,
>>
>> I have a script to display all indexes for a particular table in one
line.
>> What I did was to loop the retrieval of user tables and append the index
>> name to a variable. I encountered ora-6502 numeric or value error. The
>> code is like this:
>>
>> ws_keys char(80) := ' ';
>>
>> loop
>> :
>> ws_keys := ws_keys || index_name;
>> :
>>
>> This script used to work in oracle7.2 but now has problem with oracle8.
>Pls
>> help.
>>
>>
>>
>>
>>
>
>
Received on Thu May 13 1999 - 03:12:58 CEST