{"id":76061,"date":"2024-05-13T15:41:09","date_gmt":"2024-05-13T19:41:09","guid":{"rendered":"http:\/\/bangla.sitestree.com\/?p=76061"},"modified":"2024-05-13T15:41:09","modified_gmt":"2024-05-13T19:41:09","slug":"oracle-error-management-and-exception-handling-in-pl-sql","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=76061","title":{"rendered":"Oracle: Error management and exception handling in PL\/SQL"},"content":{"rendered":"<p>Raise Error in Oracle<\/p>\n<p>RAISE VALUE_ERROR;<\/p>\n<p>Raise Application Error in Oracle<br \/>\n<a href=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-31.png\" rel=\"attachment wp-att-76062\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-31.png?resize=750%2C750\" alt=\"\" title=\"image-31-png\" width=\"750\" height=\"750\" class=\"alignnone size-full wp-image-76062\" \/><\/a><\/p>\n<p>Create custom exception and raise it.<br \/>\n<a href=\"\" rel=\"attachment wp-att-76063\"><img loading=\"lazy\" decoding=\"async\" src=\"\" alt=\"\" title=\"image-32-png\" width=\"1024\" height=\"1024\" class=\"alignnone size-full wp-image-76063\" \/><\/a><\/p>\n<p><a href=\"\" rel=\"attachment wp-att-76064\"><img loading=\"lazy\" decoding=\"async\" src=\"\" alt=\"\" title=\"image-33-png\" width=\"1024\" height=\"1024\" class=\"alignnone size-full wp-image-76064\" \/><\/a><\/p>\n<p><strong>Handle Exception<\/strong><\/p>\n<p><a href=\"\" rel=\"attachment wp-att-76067\"><img loading=\"lazy\" decoding=\"async\" src=\"\" alt=\"\" title=\"image-36-png\" width=\"1024\" height=\"1024\" class=\"alignnone size-full wp-image-76067\" \/><\/a><\/p>\n\n\t\t<style type=\"text\/css\">\n\t\t\t#gallery-1 {\n\t\t\t\tmargin: auto;\n\t\t\t}\n\t\t\t#gallery-1 .gallery-item {\n\t\t\t\tfloat: left;\n\t\t\t\tmargin-top: 10px;\n\t\t\t\ttext-align: center;\n\t\t\t\twidth: 33%;\n\t\t\t}\n\t\t\t#gallery-1 img {\n\t\t\t\tborder: 2px solid #cfcfcf;\n\t\t\t}\n\t\t\t#gallery-1 .gallery-caption {\n\t\t\t\tmargin-left: 0;\n\t\t\t}\n\t\t\t\/* see gallery_shortcode() in wp-includes\/media.php *\/\n\t\t<\/style>\n\t\t<div id='gallery-1' class='gallery galleryid-76061 gallery-columns-3 gallery-size-thumbnail'><dl class='gallery-item'>\n\t\t\t<dt class='gallery-icon landscape'>\n\t\t\t\t<a href='http:\/\/bangla.sitestree.com\/?attachment_id=76065'><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"75\" src=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-34.png?resize=150%2C75\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" \/><\/a>\n\t\t\t<\/dt><\/dl><dl class='gallery-item'>\n\t\t\t<dt class='gallery-icon landscape'>\n\t\t\t\t<a href='http:\/\/bangla.sitestree.com\/?attachment_id=76066'><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"114\" src=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-35.png?resize=150%2C114\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" srcset=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-35.png?resize=150%2C114 150w, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-35.png?zoom=2&amp;resize=150%2C114 300w\" sizes=\"auto, (max-width: 150px) 100vw, 150px\" \/><\/a>\n\t\t\t<\/dt><\/dl>\n\t\t\t<br style='clear: both' \/>\n\t\t<\/div>\n\n<p>You could also insert into error log table and RAISE<br \/>\n<a href=\"\" rel=\"attachment wp-att-76068\"><img loading=\"lazy\" decoding=\"async\" src=\"\" alt=\"\" title=\"image-37-png\" width=\"1024\" height=\"1024\" class=\"alignnone size-full wp-image-76068\" \/><\/a><\/p>\n<p><a href=\"\" rel=\"attachment wp-att-76069\"><img loading=\"lazy\" decoding=\"async\" src=\"\" alt=\"\" title=\"image-38-png\" width=\"1024\" height=\"1024\" class=\"alignnone size-full wp-image-76069\" \/><\/a><\/p>\n<p><strong>Reference:<\/strong><br \/>\n<a href=\"https:\/\/blogs.oracle.com\/connect\/post\/error-management\">https:\/\/blogs.oracle.com\/connect\/post\/error-management<\/a><\/p>\n<pre><code>\n\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Raise Error in Oracle RAISE VALUE_ERROR; Raise Application Error in Oracle Create custom exception and raise it. Handle Exception You could also insert into error log table and RAISE Reference: https:\/\/blogs.oracle.com\/connect\/post\/error-management<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[182],"tags":[],"class_list":["post-76061","post","type-post","status-publish","format-standard","hentry","category---blog","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":76044,"url":"http:\/\/bangla.sitestree.com\/?p=76044","url_meta":{"origin":76061,"position":0},"title":"Oracle Sub Types for Data Types: Exception Block","author":"Sayed","date":"May 12, 2024","format":false,"excerpt":"An unconstrained subtype has the same set of values as its base type, so it is only another name for the base type. Syntax: SUBTYPE subtype_name IS base_type Example: SUBTYPE \"DOUBLE PRECISION\" IS FLOAT SUBTYPE Balance IS NUMBER; Constrained SubType SUBTYPE Balance IS NUMBER(8,2); Oracle Exception Block Example: Ref: https:\/\/docs.oracle.com\/cd\/B13789_01\/appdev.101\/b10807\/07_errs.htm","rel":"","context":"In &quot;\u09ac\u09cd\u09b2\u0997 \u0964 Blog&quot;","block_context":{"text":"\u09ac\u09cd\u09b2\u0997 \u0964 Blog","link":"http:\/\/bangla.sitestree.com\/?cat=182"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69920,"url":"http:\/\/bangla.sitestree.com\/?p=69920","url_meta":{"origin":76061,"position":1},"title":"Basics of Exception Handling in .Net #19","author":"Author-Check- Article-or-Video","date":"August 22, 2021","format":false,"excerpt":"Basics of Exception Handling in .Net Why exception handling? In your applications, unexpected error situations may occur that are out of your appication scope and your application logic. These are actually external to your application. For example, while you are reading a file from hard drive, the file may not\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":70311,"url":"http:\/\/bangla.sitestree.com\/?p=70311","url_meta":{"origin":76061,"position":2},"title":"Basic Information on Exception Handling in .Net #.Net Web Applications","author":"Author-Check- Article-or-Video","date":"September 1, 2021","format":false,"excerpt":"Brought from our old site: http:\/\/salearningschool.com\/displayArticle.php?table=Articles&articleID=1356&title=Basics%20of%20Exception%20Handling%20in%20.Net Basic Information on Exception Handling in .Net Why exception handling? In your applications, unexpected error situations may occur that are out of your application scope and your application logic. These are actually external to your application. For example, while you are reading a file\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":10323,"url":"http:\/\/bangla.sitestree.com\/?p=10323","url_meta":{"origin":76061,"position":3},"title":"Simplifies the setting of native look and feel","author":"","date":"August 26, 2015","format":false,"excerpt":"WindowUtilities.java Simplifies the setting of native look and feel. #################### import javax.swing.*; import java.awt.*;\u00a0\u00a0 \/\/ For Color and Container classes. \/** A few utilities that simplify using windows in Swing. \u00a0* ################### public class WindowUtilities { \u00a0 \/** Tell system to use native look and feel, as in previous \u00a0\u00a0\u2026","rel":"","context":"In &quot;Code . Programming Samples . \u09aa\u09cd\u09b0\u09cb\u0997\u09cd\u09b0\u09be\u09ae \u0989\u09a6\u09be\u09b9\u09b0\u09a8&quot;","block_context":{"text":"Code . Programming Samples . \u09aa\u09cd\u09b0\u09cb\u0997\u09cd\u09b0\u09be\u09ae \u0989\u09a6\u09be\u09b9\u09b0\u09a8","link":"http:\/\/bangla.sitestree.com\/?cat=1417"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":72968,"url":"http:\/\/bangla.sitestree.com\/?p=72968","url_meta":{"origin":76061,"position":4},"title":"What else is happening&#8230; in the market","author":"Sayed","date":"March 11, 2022","format":false,"excerpt":"\"What else is happening... Biggest bond deal in years: AT&T-Discovery (T, DISCA) raise $30B. Rivian (RIVN) slides to new low after halving production outlook. Oracle (ORCL) plunges as fiscal Q3 results miss expectations. After Amazon (AMZN), these companies could follow a stock split wave. Boycott: Disney (DIS) pauses all business\u2026","rel":"","context":"In &quot;\u09ac\u09cd\u09b2\u0997 \u0964 Blog&quot;","block_context":{"text":"\u09ac\u09cd\u09b2\u0997 \u0964 Blog","link":"http:\/\/bangla.sitestree.com\/?cat=182"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":26791,"url":"http:\/\/bangla.sitestree.com\/?p=26791","url_meta":{"origin":76061,"position":5},"title":"Simplifies the setting of native look and feel #Programming Code Examples #Java\/J2EE\/J2ME #Layout Managers","author":"Author-Check- Article-or-Video","date":"May 1, 2021","format":false,"excerpt":"WindowUtilities.java Simplifies the setting of native look and feel. #################### import javax.swing.*; import java.awt.*; \/\/ For Color and Container classes. \/** A few utilities that simplify using windows in Swing. * ################### public class WindowUtilities { \/** Tell system to use native look and feel, as in previous * releases.\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/76061","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=76061"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/76061\/revisions"}],"predecessor-version":[{"id":76070,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/76061\/revisions\/76070"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=76061"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=76061"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=76061"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}