Using the 'IN' Comparison Operator in a Cursor

From: Darren Gray <dgray_at_fytek.com>
Date: 7 Mar 2002 12:44:26 -0800
Message-ID: <6467f141.0203071244.f7ff8e5_at_posting.google.com>

Ok, I could use a little help.

I'm trying to create a cursor in PL/SQL in a Form (Forms 4.5):

Cursor A_CUR is
 SELECT
   .....
   .....
 WHERE FIELD1 IN (:BLOCK1.FIELD); My problem is with passing the variable :BLOCK1.FIELD. Let's assume that FIELD1 and :BLOCK1.FIELD are both varchar2. What format does
:BLOCK1.FIELD need to be in?

I've tried formatting it so that it looks like ('XXX','YYY','ZZZ') but
the Select statement doesn't like is when I say 'WHERE FIELD1 IN

:BLOCK1.FIELD', so I tried formatting it as 'XXX','YYY','ZZZ', and
saying 'WHERE FIELD1 IN (:BLOCK1.FIELD)', but that obviously doesn't work.

Any help is appreciated. I'm guessing that it's something that I'm just overlooking, assuming that this can even be done.

Sincerely,

dgray_at_fytek.com Received on Thu Mar 07 2002 - 21:44:26 CET