Re: Update through a DBLink

2003-07-25 Thread Peter . McLarty
through a DBLink There is or at least was a problem if you had a autonomous transaction across a dblink with a commit. [EMAIL PROTECTED] 7/24/2003 10:59:27 AM One of or developers is work on a routine that will trigger a procedure that will use a dblink to update a table on another database

Update through a DBLink

2003-07-24 Thread Smith, Ron L.
One of or developers is work on a routine that will trigger a procedure that will use a dblink to update a table on another database. It seems like I remember that something about a problem with procedures, dblinks, updates? Does anyone remember anything about that? Thanks! Ron -- Please see

RE: Update through a DBLink

2003-07-24 Thread Jamadagni, Rajendra
Title: RE: Update through a DBLink No .. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art

RE: Update through a DBLink

2003-07-24 Thread Richard Ji
If the remote table uses object types, you will have trouble updating it from your local procedure. Richard -Original Message- Sent: Thursday, July 24, 2003 11:59 AM To: Multiple recipients of list ORACLE-L One of or developers is work on a routine that will trigger a procedure that

Re: Update through a DBLink

2003-07-24 Thread John Shaw
There is or at least was a problem if you had a autonomous transaction across a dblink with a commit. [EMAIL PROTECTED] 7/24/2003 10:59:27 AM One of or developers is work on a routine that will trigger a procedurethat will use a dblink to update a table on another database. It seemslike I