Print Thread
Page 1 of 2 1 2
Reload of database objects for Code Assistant
#44771 10/17/12 04:42 PM
Joined: Oct 2012
Posts: 8
S
Member
OP Offline
Member
S
Joined: Oct 2012
Posts: 8
Is it possible to reload the database objects when using Code Assistant? I am working in PL/SQL Developer and then I create new tables using SQL*Plus. This new tables do not show when I is using Code Assistant. I have to close PL/SQL Developer and reopen it. Is there a option to force reload of database objects?

Re: Reload of database objects for Code Assistant
SvenBrennaAveva #44778 10/18/12 09:22 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
The new table is available for the Code Assistant when listing columns, but it is not available for auto-completion of the table name itself. The list of tables is fetched once at the start of the session. There is currently no option to reload it.


Marco Kalter
Allround Automations
Re: Reload of database objects for Code Assistant
Marco Kalter #44791 10/19/12 09:16 AM
Joined: Apr 2007
Posts: 96
Germany
B
Member
Offline
Member
B
Joined: Apr 2007
Posts: 96
Germany
Maybe you can add the feature to reload on reconnect, as suggested in an earlier thread.
This would be an easier way to get the new objects.

Last edited by Benjamin L; 10/19/12 09:17 AM.
Re: Reload of database objects for Code Assistant
Benjamin L #44793 10/19/12 09:23 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
I have added this to the list of enhancement requests.


Marco Kalter
Allround Automations
Re: Reload of database objects for Code Assistant
Benjamin L #44794 10/19/12 10:09 AM
Joined: Aug 2011
Posts: 339
T
Member
Offline
Member
T
Joined: Aug 2011
Posts: 339
Plus PLD should extend its internal object list when any CREATE command is issued (either implicitly or explicitly).

Re: Reload of database objects for Code Assistant
T-Gergely #44798 10/19/12 12:17 PM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
I have added this to the list of enhancement requests as well.


Marco Kalter
Allround Automations
Re: Reload of database objects for Code Assistant
Marco Kalter #44803 10/21/12 10:07 AM
Joined: Oct 2012
Posts: 8
S
Member
OP Offline
Member
S
Joined: Oct 2012
Posts: 8
I would rather have a "reload" button than do a reconnect to the database to reload the database objects. Sometimes I have to work against customer databases and the connection has to be approved and if I have to reconnect then a new approval must be issued.

Re: Reload of database objects for Code Assistant
SvenBrennaAveva #44818 10/23/12 01:01 PM
Joined: Apr 2007
Posts: 96
Germany
B
Member
Offline
Member
B
Joined: Apr 2007
Posts: 96
Germany
Would be fine for me, too. But i think an reload-on-create-command-option as suggested from T-Gergely would be the best way. Manually reloading is no more necassary.

Last edited by Benjamin L; 10/23/12 01:01 PM.
Re: Reload of database objects for Code Assistant
Benjamin L #44823 10/24/12 07:38 AM
Joined: Oct 2005
Posts: 587
Belgium
Member
Offline
Member
Joined: Oct 2005
Posts: 587
Belgium
I support a manual reload option, because we are working in a team on the same database, and I find it more convenient just reloading this list when one of my co-workers creates a table.


Roeland
Re: Reload of database objects for Code Assistant
Roeland #46008 02/08/13 10:33 PM
Joined: Dec 2005
Posts: 2,004
Roima Denmark
Member
Offline
Member
Joined: Dec 2005
Posts: 2,004
Roima Denmark
Please add this function (reload database objects) in version 10. You must have a method doing this already during startup, so it should be fairly easy to add an entry to the key configuration list.

Page 1 of 2 1 2

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.030s Queries: 15 (0.010s) Memory: 2.5609 MB (Peak: 3.0427 MB) Data Comp: Off Server Time: 2024-05-18 20:50:08 UTC
Valid HTML 5 and Valid CSS