Export data from tables with lower or mixed case names results in error.

[Michael D]

Hello,

We encountered a problem in the Export Data functionality of PL/SQL Developer 11:

When a table is created with a lower case or a mixed case name, The Export Data function results in an error Table or View does not exists. This error happens in both SQL Inserts and PL/SQL Developer export.

Since Oracle supports the use of mixed case table names and some out-of-the-box applications seem to use this option, I think PL/SQL Developer should be able to handle this. Can this please be fixed?

Please note: the generated insert-statements should also have the table names enclosed in double quotes, so importing the exported data works too.

Best Regards,
Michael Doel
Truston Solutions B.V.

 

[Marco Kalter]

We'll check it out and will try to fix it.