Please, someone jog my memory for me while I search ...MS Reporting svcs + Multi-Selects
Date: Thu, 28 Jun 2012 16:29:38 -0500
Message-ID: <C5533BD628A9524496D63801704AE56D75B2BA02EC_at_SPOBMEXC14.adprod.directory>
I have a developer creating a report in Microsoft Reporting Services that calls a pl/sql procedure. This report uses a multi-select option into a variable and he passes the variable to the procedure such as:
(pseudo query)
SELECT T.col1, T.col2
FROM some_table T
WHERE INSTR (P_BOATNAME, T.BOATNAME) > 0
/
The P_BOATNAME variable comes into Oracle as 'BOAT1, BOAT2, BOAT3' and breaks an IN statement as such.
The INSTR is annoying as it applies a function to the COLUMN and I would prefer to remove it to take advantage of an available index.
I know there is a way to pass a list of multiselect columns into a procedure as an IN statement but I can't for the life of me seem to find it.
Thanks!
Chris Taylor
"Quality is never an accident; it is always the result of intelligent effort." -- John Ruskin (English Writer 1819-1900)
Any views and/or opinions expressed herein are my own and do not necessarily reflect the views of Ingram Industries, its affiliates, its subsidiaries or its employees.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 28 2012 - 16:29:38 CDT