Change Window gives New Program Window

Gustavo

Member³
Hi,

We have a deploy tool that requires us to use some commands before and after object scripts.
So we have:

Code:
spool log_file_name.txt
Create Or Replace Procedure ...
End proc_name;
/
show errors

spool off

exit
This is saved as .prc, so default window type is Program Window. I usually comment and uncomment these extra lines, and I switch a lot between Program Window and SQL Window. The problem is:
1. Open the script
2. Change Window to SQL Window
3. Change Window to Program Window

PLD will say I have a new Program Window.

Also, as an enhancement request, would it be possible to define these extra lines somewhere else? Script prefix and sufix? The possibility of using substitution variables for filenames would be a plus.

Regards,
Gustavo
 
You can keep these extra statements in the Program Window, so that there is no need to switch or configure suffixes/prefixes. Just go to Tools > Preferences > Program Window and enable the "Ignore unrecognized PL/SQL" option.
 
Back
Top