Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MultiSelect parameters with oracle

Status
Not open for further replies.

roberthagan

Technical User
May 9, 2006
27
US
I'm planning a deployment of RS that uses stored procedures to parse out multiselect paramters, but I'd like to do this in our old system without a stored procedure.
Im currently using Visual Studio 2005 with SP2, running against Oracle 8i.

I found a proposed solution at SQL Server Central
(the entry by dph-446223 on page one)

Translated to oracle syntax the where clause is this:
WHERE :)CommaDelimtedList || ',' LIKE '%' || TableColumnToCompareTo || ',%' OR @CommaDelimtedList = '')

This query works in Oracle/TOAD, and in the query section of Reporting Services, but then doesn’t work in the actual report unless only one item is selected. There an oracle error:Invalid relational operator appears. Sounds like the list in not getting parsed into separate elements here.
Does anyone have an idea why?

Thanks
Bob
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top