Re: Error is oracle stored procedure

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 07 Sep 2006 07:07:53 +0200
Message-ID: <e8avf21q81c34dkhtbbu46miemtas7mirp@4ax.com>

On 6 Sep 2006 15:17:59 -0700, "KK" <krallabandi_at_gmail.com> wrote:

>I want to check recnum before updating salary as in teh query.
>
>I will be doing it thru oracle stored procedure and by declaring
>variable vDupTxt.
>
>It gives me error ORA-01722 invalid number ORA-06512. How to handle
>this?
>
>vDupTxt := ''' 1, 5 ''';
>
>update employee set salary = 100 where recnum in ( vDupTxt )
>
>Thanks,

Please stop multi-posting, or be prepared to be ignored.

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu Sep 07 2006 - 00:07:53 CDT