Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

FORALL & MERGE

Status
Not open for further replies.
pflakes

pflakes

Technical User
Jan 27, 2004
31
US
Is it possible to use a MERGE within the body of a FORALL statement? I'm trying to optimize a few things and replace some cursors with BULK COLLECT's. I need to maintain the merge statement due to the continual updates to the data.
Code: 
FORALL indx in rptid.FIRST.. rptid.LAST 

MERGE INTO ....

The error returned is:
PLS-00435: DML statement without BULK In-BIND cannot be used inside FORALL

 
Status
Not open for further replies.

Similar threads

TheLazyPig
  • Locked
  • Question
Merge Into with multiple execution 1
Replies
1
Views
312
carp
carp
dbomrrsm
  • Locked
  • Question
Help with merge 1
Replies
6
Views
70
dbomrrsm
dbomrrsm
scottyjohn
  • Locked
  • Question
Rollback after Merge?
Replies
7
Views
223
Thargy
Thargy
dbomrrsm
  • Locked
  • Question
FORALL problem 1
Replies
3
Views
32
Dagon
Dagon
DarkWorlds
  • Locked
  • Question
Merge update insert error. ORA-30926
Replies
3
Views
75
DarkWorlds
DarkWorlds

Part and Inventory Search

Sponsor

Back
Top