Using the 'IN' Comparison Operator in a Cursor
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