Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Commit required after select over Dblink

976379Dec 31 2012 — edited Dec 31 2012
Hi,
whenever i am trying to fire select query over a dblink, even though the transaction is complete and all rows are fetched, i am being asked for commit/rollback by the tool. I need to know that this is fine for any tool, but what will happen to the session if the same is being initiated by a view.

i mean, i am selecting from a view but the view is internally firing a query over dblink, in that case do the session will remain open or it will be closed by oracle?

Thanks.
This post has been answered by CloudDB on Dec 31 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 28 2013
Added on Dec 31 2012
6 comments
12,630 views