Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Error is oracle stored procedure
Thank you!
Morgan's Library explained me what I wanted.
DA Morgan wrote:
> 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
Received on Thu Sep 07 2006 - 13:34:42 CDT
![]() |
![]() |