-
MERGE with BULK BINDING
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
-
Originally Posted by 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
Did you try it out? If so, what's the error you got?
Tamil
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|