I'd like to pass a set of record identifiers into an Oracle procedure, using a comma-separated string. I want to place this into a temp table and then join off that in further processing. How would I go about this?

Better approaches than CSV's would be great to hear about too. I'm using ODP.Net for data access.