MERGE with BULK BINDING

[yodah]

Hi Guys

Can the MERGE statement in PL/SQL be used with Bulk Binding FORALL like with inserting and if so how? Or if not whats a good work around?

Cheers

[tamilselvan]

Hi Guys

Can the MERGE statement in PL/SQL be used with Bulk Binding FORALL like with inserting and if so how? Or if not whats a good work around?

Cheers

Did you try it out? If so, what's the error you got?

Tamil

[slimdave]

A Merge command can be baed on a table, view or subquery, so if you could use a pipelined function to read the contents of your collection and cast it into a table then you might have some luck. Otherwise bulk insert your data into a global temporary table and base the MERGE on that.