1arryb
User
Sep 16, 2009, 8:58 AM
Post #2 of 2
(3073 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
|
MAIN
SEARCH
WHO'S 
LOG 