one obvious error - merge condition (on clause) must be in parenthesis i.e ON (address.add_id = tmpadd.add_id)
cannot find any immediate problems any more Although why do you need merge for this case? It seems just a simple update would be enough... Gints Plivna http://www.gplivna.eu --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
