Passing a List to Oracle 8i Stored Proc

[Dave Carabetta]

I'm trying to pass a list in to an Oracle 8i stored proc (using MX 6.1), but
it doesn't seem to be working. This list would be something like:

BO,AT,CA

and in the proc, the query would be something like

SELECT foo
FROM myTable
WHERE code IN (theList)

Is this even possible? If I pass in one value, the proc works fine, but as
soon as I try and use a list, I get no results back.

Thanks,
Dave.

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---