Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: IN comparison operator in PL/SQL cursor

RE: IN comparison operator in PL/SQL cursor

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Wed, 13 Dec 2006 17:11:04 -0500
Message-ID: <AA29A27627F842409E1D18FB19CDCF270AA24AD2@AABO-EXCHANGE02.bos.il.pqe>


Go to http://asktom.oracle.com/ and do a search on "variable in list".

--

Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning

There is nothing so useless as doing efficiently that which shouldn't be done at all. -Peter F. Drucker, 1909-2005

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Geoffrey E. Quelch Sent: Wednesday, December 13, 2006 3:57 PM To: oracle-l
Subject: IN comparison operator in PL/SQL cursor

Hi,
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
    )
    IS

(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.

Thanks
Geoff Quelch

--

Geoff Quelch
Email: gequelch_at_frii.net

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Dec 13 2006 - 16:11:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US