Re: ora-6502 - can't append string

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 Wed May 12 1999 - 14:51:40 CEST