Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Stored Proc issues

Re: Oracle Stored Proc issues

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 06 Sep 2006 12:45:13 -0700
Message-ID: <1157571909.747965@bubbleator.drizzle.com>


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 Group
Received on Wed Sep 06 2006 - 14:45:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US