Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Adding "Set define off" to package/function/procedure export

ArpodApr 11 2014 — edited Apr 23 2014

If my packages, triggers, procedures, functions, whatever else with PL/SQL inside contains "&" symbol, then after using "Tools->Database Export" to export them to worksheet and trying to execute it, SQLDev (or SQL*Plus, actually) prompts me to enter a value, unless I write "SET DEFINE OFF" at the beginning of the script. It would be nice if it was automatically added on export.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 21 2014
Added on Apr 11 2014
2 comments
2,433 views