Re: merge into using perl from array

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 18 Aug 2009 14:09:43 -0700
Message-ID: <bf46380908181409m3bb4d7f4x2f614303e2276581_at_mail.gmail.com>

On Tue, Aug 18, 2009 at 1:58 PM, Barbara Baker <barb.baker_at_gmail.com> wrote:

> Does anyone have an example that uses the "merge into" syntax where the
> source would be an array in perl instead of a "real" table? Is it
> possible? Oracle 9.2.0.7 Sun O/S 9 perl 5.8.5
>

execute_array should do what you need.

Examine the DBI docs and build a prototype to see how it works.

I have used it, but don't have a good example to share.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Aug 18 2009 - 16:09:43 CDT