Commit required after select over Dblink
976379Dec 31 2012 — edited Dec 31 2012Hi,
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.