How to refresh code completion information?

[Claus Pedersen]

I am writting a package which uses a table.

If I update the table (for instance rename columns), the code completion information still shows the old table information.

How do I update this information?

I have tried to refresh the table in the browser but it did not change anything. A workaround is to save the package and then re-open the package in a new program window. Now code completion shows the correct table information.

 

[Marco Kalter]

The Code Assistant buffers the most recently used object definition. If you alter the object, you would first need to use the Code Assistant for an other object to "clear" the buffered definition.

 

[Claus Pedersen]

OK, that clears things up.
Thanks

 

[F. van Boven]

Workaround for me: A quick reconnect to the database refreshes the Code Assistant.

This "problem" is actual quite annoying. After the creation of a new table, the newly created table is not known in the Code Assistant. Since I'm lazy as f**k this forces me type complete SQL statements on the new table (Or I reconnect to the database)

 

[Claus Pedersen]

To Marcus:

If you alter the object, you would first need to use the Code Assistant for an other object to "clear" the buffered definition.

This is not always enough, as you can see from the post from F. van Boven, it is often neccesary to reconnect to be able to see newly defined objects in the code completion.

Could you please correct the code completion functionality so it flushes the buffer each time a table/view/package etc. is modified in the current PLD session? Also sql commands (executed via SQL or command windows) must always flush the code completion buffer because they could result in DDL commands. If this is a performance problem, this could be a user-defined option