On Wed, Feb 06, 2002 at 12:26:23PM -0000, Rohan Holt wrote: > I would like to use DBI & DBD::Oracle to call a third party (proprietry) > stored proc API which happens to use PL/SQL tables as out parameters in some > cases. > > Problem: > Having scanned many of the questions & answers relating to stored procs in > this list it seems that this is not possible. The closest I came to a > solution is binding to an open cursor. As I have no control over the coding > of the stored proc this is not really an option.
You can write a PL/SQL wrapper. > Has anyone been able to return data from PL/SQL tables using DBI with > Oracle? Is there likely to be any support for this soon (if there isn't > already)? Not unless someone (ie a company) sponsors the work to raise it's priority (I'll get to it eventually but I've a pile of other DBI, DBD::Oracle, Oracle::OCI, and extproc_perl work to do first). Having said that, Andy Sautins <[EMAIL PROTECTED]> (CC'd) has a patch for DBD::Oracle that implements collections. Something along those line will get into DBD::Oracle eventually (probably in conjunction with Oracle::OCI). Tim.
