Reload of database objects for Code Assistant

[SvenBrennaAveva]

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?

 

[Marco Kalter]

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.

 

[Benjamin L]

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.

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[T-Gergely]

Plus PLD should extend its internal object list when any CREATE command is issued (either implicitly or explicitly).

 

[Marco Kalter]

I have added this to the list of enhancement requests as well.

 

[SvenBrennaAveva]

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.

 

[Benjamin L]

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.

 

[Roeland]

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.

 

[Claus Pedersen]

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.

 

[William Robertson]

Agreed - often in development you create some tables and then have to live without code-assistance until you close down and reload your entire PL/SQL Developer session. If you have a load of windows open that can take some time and effort. A button please?

 

[Benjamin L]

Is this feature added to Vers 10? I couldn't find it.

 

[Benjamin L]

I think there are several threads to this Problem, i choosed thsi one.
Will it be possible to see tables, objects etc. in code completion after creating them in Version 11.

 

[Benjamin L]

Hey Marco,

did you add this feature to PSD? I couldn't find it?

Regards Benjamin