export tables/export user objects.

[Jonathan Taylor]

There appears to be a discrepancy between the SQL produced by export tables and export user objects.

The SQL produced by export tables includes the two lines:-

set feedback off
set define off

(The last line is the important one - it stops SQLPlus/Command Window from prompting the user for a value when a "&" is encountered).

The SQL proceduced by export user objects does not.

I think these two lines (especially set define off) should appear in both SQLs.

"&" can appear in the source of a package "user object".

 

[Marco Kalter]

I have added this to the list of enhancement requests.