tag:blogger.com,1999:blog-13265058.post7725087557473723891..comments2023-10-28T23:33:56.980+11:00Comments on Sydney Oracle Lab: Disabling specifc PL/SQL Warning messagesSydOraclehttp://www.blogger.com/profile/08828771074492585943noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-13265058.post-889329608912672492010-01-14T20:13:51.451+11:002010-01-14T20:13:51.451+11:00Thanks Gary - appreciate the response.
I'll l...Thanks Gary - appreciate the response.<br /><br />I'll look out forthe full review of the book.<br /><br />M.mathewbutlerhttps://www.blogger.com/profile/04733010552235144796noreply@blogger.comtag:blogger.com,1999:blog-13265058.post-39389780793173529502010-01-14T14:06:39.832+11:002010-01-14T14:06:39.832+11:00You can compile specific objects with different le...You can compile specific objects with different levels of warning. I don't think it gets any lower level than that, or allows for any meta-data. Maybe something could be done with a database trigger, but that's not much better than comments.<br /><br />ALTER PACKAGE test_warn compile plsql_warnings='ENABLE:ALL','DISABLE:07203';<br />Package altered.<br />ALTER PACKAGE test_warn compile plsql_warnings='DISABLE:ALL','ENABLE:07203';<br />SP2-0809: Package altered with compilation warnings<br /><br />I'll do a fuller review of the book in a couple of weeks. The earlier part is fairly introductory so if you know PL/SQL it takes dedication to read it to pick up new details. The later part (security, performance, objects) is more interesting for me.SydOraclehttps://www.blogger.com/profile/08828771074492585943noreply@blogger.comtag:blogger.com,1999:blog-13265058.post-10687703980195107902010-01-13T23:21:36.477+11:002010-01-13T23:21:36.477+11:00Hi Gary,
This looks like the warning is disabled ...Hi Gary,<br /><br />This looks like the warning is disabled for the entire session involved in the compile.<br /><br />Are you aware of any means to disable the warning for a specific usage? <br /><br />Let's say I have two warnings in a package and I only want to disable the warning for one of these usages.<br /><br />Ideally, I'd like to add meta-data to the proc/function so that the compiler does not give a warning, and the next developer can see in the code that this is a deliberate usage. <br /><br />Language supported meta-data would be a more robust means of achieving this rather than a comment, which is the fall back approach.<br /><br />Are you happy with the new edition? Recommended? This one is on my reading list, but still looking for additional positive reviews.<br /><br />Cheers,<br /><br />Mathew Butlermathewbutlerhttps://www.blogger.com/profile/04733010552235144796noreply@blogger.com