{"id":1916,"date":"2026-09-30T10:30:34","date_gmt":"2026-09-30T14:30:34","guid":{"rendered":"https:\/\/molecularsciences.org\/content\/?p=1916"},"modified":"2025-09-24T16:38:17","modified_gmt":"2025-09-24T20:38:17","slug":"articles-to-write","status":"publish","type":"post","link":"https:\/\/molecularsciences.org\/content\/articles-to-write\/","title":{"rendered":"Articles to Write"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\"><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>6. Exception Handling<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Predefined Oracle Exceptions<\/li>\n\n\n\n<li>User-Defined Exceptions<\/li>\n\n\n\n<li>Exception Propagation<\/li>\n\n\n\n<li>RAISE_APPLICATION_ERROR<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>7. Procedures and Functions<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Creating Stored Procedures<\/li>\n\n\n\n<li>Creating Functions<\/li>\n\n\n\n<li>IN, OUT, and INOUT Parameters<\/li>\n\n\n\n<li>Overloading Procedures and Functions<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>8. Packages<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Creating and Using Packages<\/li>\n\n\n\n<li>Package Specification<\/li>\n\n\n\n<li>Package Body<\/li>\n\n\n\n<li>Private vs Public Package Components<\/li>\n\n\n\n<li>Forward Declarations<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>9. Triggers<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Types of Triggers (Row-Level, Statement-Level)<\/li>\n\n\n\n<li>BEFORE and AFTER Triggers<\/li>\n\n\n\n<li>INSTEAD OF Triggers<\/li>\n\n\n\n<li>System Triggers<\/li>\n\n\n\n<li>Compound Triggers<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>10. PL\/SQL Collections<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>PL\/SQL Tables (Associative Arrays)<\/li>\n\n\n\n<li>Nested Tables<\/li>\n\n\n\n<li>VARRAYs<\/li>\n\n\n\n<li>Collection Methods (COUNT, EXTEND, DELETE, TRIM, EXISTS, FIRST, LAST)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>11. Dynamic SQL<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>EXECUTE IMMEDIATE<\/li>\n\n\n\n<li>DBMS_SQL Package<\/li>\n\n\n\n<li>Binding Variables in Dynamic SQL<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>12. Transactions in PL\/SQL<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>COMMIT, ROLLBACK, SAVEPOINT<\/li>\n\n\n\n<li>Autonomous Transactions<\/li>\n\n\n\n<li>Locking Mechanisms<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>13. Bulk Processing in PL\/SQL<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>BULK COLLECT<\/li>\n\n\n\n<li>FORALL Statement<\/li>\n\n\n\n<li>Performance Benefits of Bulk Processing<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>14. Working with XML and JSON in PL\/SQL<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Using DBMS_XMLGEN and DBMS_XSLPROCESSOR<\/li>\n\n\n\n<li>Working with JSON (JSON_OBJECT, JSON_QUERY)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>15. Advanced PL\/SQL Concepts<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>PL\/SQL Compiler and Optimization (Pipelined Table Functions)<\/li>\n\n\n\n<li>Dependency Management<\/li>\n\n\n\n<li>Secure Coding Practices in PL\/SQL<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><\/h2>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>2. SQL Execution and Query Errors<\/strong><\/h2>\n\n\n\n<p><\/p>\n\n\n\n<ol start=\"11\" class=\"wp-block-list\">\n<li><strong>ORA-00979:<\/strong> Not a GROUP BY expression<\/li>\n\n\n\n<li><strong>ORA-01000:<\/strong> Maximum open cursors exceeded<\/li>\n\n\n\n<li><strong>ORA-01403:<\/strong> No data found<\/li>\n\n\n\n<li><strong>ORA-01422:<\/strong> Exact fetch returns more than requested number of rows<\/li>\n\n\n\n<li><strong>ORA-01438:<\/strong> Value larger than specified precision allowed for this column<\/li>\n\n\n\n<li><strong>ORA-01722:<\/strong> Invalid number<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>3. Constraint and Integrity Errors<\/strong><\/h2>\n\n\n\n<ol start=\"21\" class=\"wp-block-list\">\n<li><strong>ORA-00001:<\/strong> Unique constraint violated<\/li>\n\n\n\n<li><strong>ORA-02290:<\/strong> Check constraint violated<\/li>\n\n\n\n<li><strong>ORA-02291:<\/strong> Integrity constraint (foreign key) violated \u2013 parent key not found<\/li>\n\n\n\n<li><strong>ORA-02292:<\/strong> Integrity constraint violated \u2013 child record found<\/li>\n\n\n\n<li><strong>ORA-04098:<\/strong> Trigger <code>&lt;trigger_name&gt;<\/code> is invalid and failed re-validation<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>4. Cursor and Transaction Errors<\/strong><\/h2>\n\n\n\n<ol start=\"26\" class=\"wp-block-list\">\n<li><strong>ORA-01001:<\/strong> Invalid cursor<\/li>\n\n\n\n<li><strong>ORA-06511:<\/strong> PL\/SQL: Cursor already open<\/li>\n\n\n\n<li><strong>ORA-06512:<\/strong> At line <code>&lt;number&gt;<\/code> (backtrace error)<\/li>\n\n\n\n<li><strong>ORA-06519:<\/strong> Active autonomous transaction detected<\/li>\n\n\n\n<li><strong>ORA-06550:<\/strong> Line <code>&lt;number&gt;<\/code>, Column <code>&lt;number&gt;<\/code>: Compilation unit errors<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>5. Locking and Concurrency Errors<\/strong><\/h2>\n\n\n\n<ol start=\"31\" class=\"wp-block-list\">\n<li><strong>ORA-00054:<\/strong> Resource busy and acquire with NOWAIT specified<\/li>\n\n\n\n<li><strong>ORA-00060:<\/strong> Deadlock detected while waiting for resource<\/li>\n\n\n\n<li><strong>ORA-01555:<\/strong> Snapshot too old \u2013 rollback segment too small<\/li>\n\n\n\n<li><strong>ORA-02049:<\/strong> Timeout: Distributed transaction waiting for lock<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>6. Storage and Memory Errors<\/strong><\/h2>\n\n\n\n<ol start=\"35\" class=\"wp-block-list\">\n<li><strong>ORA-01652:<\/strong> Unable to extend temp segment by <code>&lt;number&gt;<\/code> in tablespace <code>&lt;tablespace_name&gt;<\/code><\/li>\n\n\n\n<li><strong>ORA-04030:<\/strong> Out of process memory when trying to allocate <code>&lt;bytes&gt;<\/code><\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>7. PL\/SQL Runtime Errors<\/strong><\/h2>\n\n\n\n<ol start=\"37\" class=\"wp-block-list\">\n<li><strong>ORA-06502:<\/strong> PL\/SQL: Numeric or value error<\/li>\n\n\n\n<li><strong>ORA-06503:<\/strong> PL\/SQL: Function returned without value<\/li>\n\n\n\n<li><strong>ORA-06504:<\/strong> PL\/SQL: Return types of Result Set variables do not match<\/li>\n\n\n\n<li><strong>ORA-06508:<\/strong> PL\/SQL: Could not find program unit being called<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>8. Large Object (LOB) and File Handling Errors<\/strong><\/h2>\n\n\n\n<ol start=\"41\" class=\"wp-block-list\">\n<li><strong>ORA-22275:<\/strong> Invalid LOB locator specified<\/li>\n\n\n\n<li><strong>ORA-22285:<\/strong> Non-existent directory or file for BFILE operation<\/li>\n\n\n\n<li><strong>ORA-22288:<\/strong> File or LOB operation failed<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>9. Network and Connectivity Issues<\/strong><\/h2>\n\n\n\n<ol start=\"44\" class=\"wp-block-list\">\n<li><strong>ORA-03113:<\/strong> End-of-file on communication channel<\/li>\n\n\n\n<li><strong>ORA-03135:<\/strong> Connection lost contact<\/li>\n\n\n\n<li><strong>ORA-12537:<\/strong> TNS: Connection closed<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>10. Miscellaneous PL\/SQL Errors<\/strong><\/h2>\n\n\n\n<ol start=\"47\" class=\"wp-block-list\">\n<li><strong>PLS-00225:<\/strong> Subprogram or cursor &#8216;NAME&#8217; reference is ambiguous<\/li>\n\n\n\n<li><strong>PLS-00597:<\/strong> Expression &#8216;X&#8217; in the INTO list is of wrong type<\/li>\n\n\n\n<li><strong>PLS-00642:<\/strong> Local collection types not allowed in SQL statements<\/li>\n\n\n\n<li><strong>PLS-00707:<\/strong> Unsupported construct or feature encountered<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>6. Exception Handling 7. Procedures and Functions 8. Packages 9. Triggers 10. PL\/SQL Collections 11. Dynamic SQL 12. Transactions in PL\/SQL 13. Bulk Processing in PL\/SQL 14. Working with XML and JSON in PL\/SQL 15. Advanced PL\/SQL Concepts 2. SQL Execution and Query Errors 3. Constraint and Integrity Errors 4. Cursor and Transaction Errors 5. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[515],"tags":[],"class_list":["post-1916","post","type-post","status-publish","format-standard","hentry","category-oracle"],"_links":{"self":[{"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/posts\/1916","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/comments?post=1916"}],"version-history":[{"count":12,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/posts\/1916\/revisions"}],"predecessor-version":[{"id":2032,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/posts\/1916\/revisions\/2032"}],"wp:attachment":[{"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/media?parent=1916"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/categories?post=1916"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/tags?post=1916"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}