
1arryb
User
Sep 16, 2009, 8:58 AM
Post #2 of 2
(6007 views)
|
Re: [vpahwa] Passing array parameter to oracle stored procedure
[In reply to]
|
Can't Post
|
|
Hi vpahwa, 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://www.mail-archive.com/dbi-users@perl.org/msg32055.html. Good luck, Larry
|