Hi,
We have a deploy tool that requires us to use some commands before and after object scripts.
So we have:
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
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
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