Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Stored Proc issues
KK wrote:
> That sounds good. I use the value in the update statement.
>
> something like
> update ... where xyz in ( variable )
>
> Thanks
Then declare the variable dynamically as in:
DECLARE
myvariable mytable.mycolumn%TYPE;
BEGIN
-- Daniel Morgan University of Washington Puget Sound Oracle Users GroupReceived on Wed Sep 06 2006 - 14:45:13 CDT
![]() |
![]() |