2 Replies Latest reply on Apr 23, 2014 10:31 AM by Arpod

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


      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.