Well, after spending all day yesterday and some time this morning trying to work on my Oracle merge problem, I've decided to just do it the old fashioned way. We're going to alter the procedure to check the value of the MasterAccountId and if it's 0 (like, the MA was just created) then the procedure will run an insert, and if it's not, then it will run an update on the record that shares that MasterAccountId.
What is the difference in this and what I was trying to do you ask? Uh... nothing really. I just thought it would be cool to use that nice shiny new MERGE keyword in my PL/SQL. Foiled again...
Posts
0 comments:
Post a Comment