On Tue, 12 Mar 2002, Stephen Keller wrote: > Regarding Tim's original question, however, I thought he was trying to do > the insert into the MySql database, so I'm not sure that Oracle error > handler will impact him much. Does MySql support cursors for updates?
I replied off-line noting that I wasn't going to get any errors out of Oracle since I was just doing a "SELECT *" and my errors would come from INSERTS into MySQL. That being said, I'm now torn between using a "REPLACE" vs the other suggestions. I think I would like to keep things as generic as possible since I am cursing at the person who last had this code when it was used for an Oracle to Oracle dump and he used Oraperl. Thanks again for the suggestions. I'm not a DBA.. I just play one at work on rare occasions. :) Tim Tim Carlson Voice: (509) 376 3423 Email: [EMAIL PROTECTED] EMSL UNIX System Support
