On Fri, 26 Jul 2002 11:16:00 +0530 "Sundarraj, Senthil Kumar (Cognizant)" <[EMAIL PROTECTED]> wrote:
> I have a stored procedure in oracle accepting array as an input > parameter and array as an output parameter. how to call this procedure thru > perl DBI calls.any help at the earliest will be appreciated. Handling non-scalar arguments is on the TODO list for DBD::Oracle, but it isn't fully ready yet. You might be able to do it with Oracle::OCI, but I haven't used it and can't tell you how. Another approach would be to use an adapter package that can convert scalar lists to arrays and back. If the arrays are small enough, an anonymous block might work. -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.
