Better handling of virtual columns

[Bernhard S]

Currently the templates are unaware of virtual columns. They get listed in INSERT and UPDATE statements like any other column, but when you use them you end up with errors like

ORA-54017: UPDATE operation disallowed on virtual columns

Those templates should just use changeable=non-virtual columns.

Also in code assistant for an insert/update statement it would be great if virtual columns are not just showing up like any other, really usable column in this context.

 

[Marco Kalter]

Which PL/SQL Developer version are you using, and where do these update statements come from?

 

[Bernhard S]

I'm using Version 10.0.5.1710.
I drag and drop a table containing virtual columns from Objects - Tables into an SQL Window or Command Window and then click on "Select" or "Update" to get the DML created.

 

[Marco Kalter]

Okay, we'll enhance this.