Print Thread
Q: why does Find database objects cause an option to commit?
#36051 10/13/09 11:26 AM
Joined: Dec 2005
Posts: 2,004
Roima Denmark
Member
OP Offline
Member
Joined: Dec 2005
Posts: 2,004
Roima Denmark
Q: see above.

I have a view that uses a synonym (table on another instance accessed through a database link). When I perform a database search and include views, the buttons for commit/rollback are enabled.

Why? Is this reported by Oracle and if so, why?

Re: Q: why does Find database objects cause an option to commit?
Claus Pedersen #36052 10/13/09 01:20 PM
Joined: Sep 1999
Posts: 212
Warszawa,Poland
J
Member
Offline
Member
J
Joined: Sep 1999
Posts: 212
Warszawa,Poland
It is because every select statement over a dblink starts a transaction, and you should commit after every select over dblink.


Joachim Rupik

Browser Extender & Plot Window Team
Emberiza Software s.c.
---------------------------------------------------------
Browser Extender home: http://www.browserextender.com
Re: Q: why does Find database objects cause an option to commit?
Joachim Rupik #36055 10/13/09 02:09 PM
Joined: Dec 2005
Posts: 2,004
Roima Denmark
Member
OP Offline
Member
Joined: Dec 2005
Posts: 2,004
Roima Denmark
OK, but Marco, is it possible, that PLD auto-commits after a search to make sure that the buttons are disabled again?

Re: Q: why does Find database objects cause an option to commit?
Claus Pedersen #36063 10/14/09 10:08 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
PL/SQL Developer will only commit when all records are fetched. If it would commit before that, fetching subsequent records would lead to "ORA-01002: fetch out of sequence".


Marco Kalter
Allround Automations
Re: Q: why does Find database objects cause an option to commit?
Marco Kalter #36079 10/14/09 07:58 PM
Joined: Dec 2005
Posts: 2,004
Roima Denmark
Member
OP Offline
Member
Joined: Dec 2005
Posts: 2,004
Roima Denmark
OK, but PLD does not commit, even after the search is finished. For the user, it looks odd.


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.080s Queries: 14 (0.030s) Memory: 2.5162 MB (Peak: 3.0424 MB) Data Comp: Off Server Time: 2024-05-19 00:24:09 UTC
Valid HTML 5 and Valid CSS