procedure export

Arpod Apr 11, 2014 11:22 AM

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.

1. Re: Adding "Set define off" to package/function/procedure export

Krishna-Oracle Apr 11, 2014 11:56 AM (in response to Arpod)

I don't think export has option to add this.
you can also try set escape on
Like Show 0 Likes(0)

Actions
2. Re: Adding "Set define off" to package/function/procedure export

Arpod Apr 23, 2014 10:31 AM (in response to Krishna-Oracle)

>I don't think export has option to add this.

I see, that's too bad. Can we expect to see it in the future releases? Maybe you could just add it automatically, like you do for data export?
Like Show 0 Likes(0)

Actions

Go to original post