Re: Error is oracle stored procedure

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

On 6 Sep 2006 14:34:38 -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,

search for 'variable IN-list' on http://asktom.oracle.com

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu Sep 07 2006 - 00:01:15 CDT