IN comparison operator in PL/SQL cursor

  • From: "Geoffrey E. Quelch" <gequelch@xxxxxxxx>
  • To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 13 Dec 2006 20:57:11 +0000

I'm wondering if someone on this list can help with this problem I'm trying
to resolve.

I'm attempting to use an IN comparison operator in a PL/SQL cursor and can't
seem to get it to work.

Pseudo code follows:

    PROCEDURE GetStationDataByList (
        in_list     IN VARCHAR2
        -- Retrieval CURSOR
        CURSOR cr_retrieve IS
        SELECT SD.Value AS Value
        FROM Station_Data SD
        WHERE SD.Abbreviation IN (in_list)

(I have removed unrelated items in this cursor.)

As written, the above doesn't work, how can I modify "in_list" to get this to
work? Is this in fact even possible?

By not work, I mean no rows are returned and I don't get an error. If I move 
the select statement to sqlplus and place the
text I have in "in_list" into the operator, I get rows returned as expected.

I've consulted the Oracle documentation, and there appears to be no mention
on how this needs to be done.

Geoff Quelch

Geoff Quelch
Email: gequelch@xxxxxxxx


Other related posts: