Re: Using the 'IN' Comparison Operator in a Cursor

Hi,

have you tried it this way?

   ...WHERE FIELD1 IN (''''||:BLOCK1.FIELD||''''); May be that forms sql engine behaves different. You did not giv an exact error message, so let me guess a little bit.

Regards

dgray_at_fytek.com (Darren Gray) wrote in message news:<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 Fri Mar 08 2002 - 10:07:27 CET