ora-6502 - can't append string
From: Lai <lyekheng_at_hotmail.com>
Date: Wed, 12 May 1999 12:55:03 +0800
Message-ID: <3739095c.0_at_news.cyberway.com.sg>
Hi,
Date: Wed, 12 May 1999 12:55:03 +0800
Message-ID: <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 - 06:55:03 CEST