When compiling a package source retrieved from the database that contains conditional compilation, the settings are "forgotten" unless "reuse settings" is added to the recompilation call.
We are finding that settings are being forgotten.
For "Compile Invalid Objects" this should be fairly trivial:
- Is databasse 10.2+ ?
- Yes: append " reuse settings" to end of "compile" command
- No: carry on as normal
When rebuilding a package (procedure/function/trigger/..) retrieved from the database, this is more tricky as it would first have to retrieve the settings (from USER_STORED_SETTINGS : param_name = 'plsql_ccflags') that were last used and then re-apply then.
We use the conditional compilation feature to maintain one file for multiple versions of the application. I guess it's workable to assign these settings to a project [as suggested by another thread (from Jan 2006?)], but we don't use projects (yet) in plsqldev.
We've also run into the beautifier issue with $IF .. $END - mentioned in another thread.
We're using v7.1.5 and plan to upgrade soon*. Whilst I can see that Compiler Options now allow specification of plsql_ccflags, I see no reference to reusing settings when (re)building. Is this there? Could it be added? As another Compiler option?
* a nice answer here would certainly help my case for the spending
Thanks.
We are finding that settings are being forgotten.
For "Compile Invalid Objects" this should be fairly trivial:
- Is databasse 10.2+ ?
- Yes: append " reuse settings" to end of "compile" command
- No: carry on as normal
When rebuilding a package (procedure/function/trigger/..) retrieved from the database, this is more tricky as it would first have to retrieve the settings (from USER_STORED_SETTINGS : param_name = 'plsql_ccflags') that were last used and then re-apply then.
We use the conditional compilation feature to maintain one file for multiple versions of the application. I guess it's workable to assign these settings to a project [as suggested by another thread (from Jan 2006?)], but we don't use projects (yet) in plsqldev.
We've also run into the beautifier issue with $IF .. $END - mentioned in another thread.
We're using v7.1.5 and plan to upgrade soon*. Whilst I can see that Compiler Options now allow specification of plsql_ccflags, I see no reference to reusing settings when (re)building. Is this there? Could it be added? As another Compiler option?
* a nice answer here would certainly help my case for the spending
Thanks.
Last edited:
