Sep 16, 2009, 8:58 AM
Post #2 of 2
Re: [vpahwa] Passing array parameter to oracle stored procedure
[In reply to]
After reading up on this subject, it doesn't appear (directly) possible with DBI. What you're going to have to do, I think, is:
1. Rewrite your Oracle procedure to use delimited string parameters instead of arrays (e.g., "VALUE1|VALUE2|VALUE3..."). If you aren't allowed to re-write the procedure, you can write an adapter procedure that does the parameter conversion and calls the original procedure.
2. In perl, convert your array to a delimited string before calling the procedure. Ditto (in reverse) for output parameters.
This approach is covered at: http://firstname.lastname@example.org/msg32055.html.