Re: IN list of where condition using in a cursor

From: Mark Stratford <mark_stratford98_at_yahoo.co.uk>
Date: 7 Feb 2003 01:52:34 -0800
Message-ID: <690213b6.0302070152.3559c138@posting.google.com>

C Chang <cschang_at_maxinter.net> wrote in message news:<3E432F97.1F20_at_maxinter.net>...
> I use an explicit cursor to get multiple rows of records. My qustion is
> how to apply the variable to the IN list in the where clause. My example
> as
> CURSOR c_qty_rcvd ( i_site IN VARCHAR2,

First thing - *ALWAYS* include Oracle version in your question. Can make a big difference to replies.

Perhaps look into REF_CURSOR. Your approach so far will not work.

mark stratford Received on Fri Feb 07 2003 - 03:52:34 CST