Passing arrays to stored procedures

Anyone out there know how to pass arrays of strings and/or numbers and/or dates to Oracle 7.3 stored procedures? What I need to accomplish could be easily done with string parsing routines and embedded SQL, but the client requires this stuff to be in stored procedures. Specifically, the reporting spec calls for the creation of one or many ‘IN’ clauses within a proc, based on the data (or lack of data) in the array arguments to the proc, in combination with (optional) date range data passed as non-array arguments.

Thanks in advance for any suggestions

Steve Jovais pwr_bldr_at_hotmail.com

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Oct 27 1998 - 10:17:09 CST