Re: Error is oracle stored procedure

KK 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,

You can't do it that way.

www.psoug.org
click on Morgan's Library
click on CONDITIONS
scroll down to COMPLEX IN STATEMENT

-- 
Puget Sound Oracle Users Group