RE: IN comparison operator in PL/SQL cursor
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <gequelch@xxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 13 Dec 2006 17:11:04 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
-- 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.
Thanks
Geoff Quelch
--
Geoff Quelch
Email: gequelch@xxxxxxxx
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
