Re: Error is oracle stored procedure

From: <fitzjarrell_at_cox.net>
Date: 6 Sep 2006 14:44:51 -0700
Message-ID: <1157579091.174228.56030@m79g2000cwm.googlegroups.com>

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 need to read the newsgroup much better than you do. That will not work and it's already been explained in the thread listed below:

http://groups.google.com/group/comp.databases.oracle.server/browse_thread/thread/e5c8ca75705daf52

Please read this.

David Fitzjarrell Received on Wed Sep 06 2006 - 16:44:51 CDT