Jon,
Thanks for the reply.
As i explained earlier, I am using java (via hibernate) to control the
overall transaction.
I cannot have begin/rollback statements for dblink_exec.
Only when the entire method call from java succeeds I want the transaction to
be commited.
I dont want a funtion controlling the transaction partially. I thought there
would be easier way for letting dblink participate in the incoming transaction
(i.e. from java-jdbc method call) and commit only when the main transaction
commits.
I wanted to treat the whole updates inside the function as one, and let java
method call decide whether to commit or rollback.
thanks,
---------------------------------
You rock. That's why Blockbuster's offering you one month of Blockbuster Total
Access, No Cost.
