• Skip to primary navigation
  • Skip to main content

Tech Honey

The #1 Website for Oracle PL/SQL, OA Framework and HTML

  • Home
  • HTML
    • Tags in HTML
    • HTML Attributes
  • OA Framework
    • Item in OAF
    • Regions in OAF
    • General OAF Topics
  • Oracle
    • statement
    • function
    • clause
    • plsql
    • sql

EXCEPTIONHandlingPLSQL

WHEN OTHERS CLAUSE in Exceptions in Oracle PLSQL

December 21, 2012 by techhoneyadmin

WHEN OTHERS CLAUSE in PLSQL Exceptions:- WHEN OTHERS CLAUSE in PLSQL Exceptions is used to capture an exception that’s not handled by our Named System Exception or Named Programmer Defined Exception. The plsql syntax for using WHEN OTHERS Clause in an Exception within a procedure is: CREATE [OR REPLACE] PROCEDURE procedure_name [ (parameter [,parameter]) ] […]

Filed Under: plsql Tagged With: EXCEPTIONHandlingPLSQL, how to write WHEN OTHERS Clause in exception in oracle plsql, Oracle plsql WHEN OTHERS Clause in exception handling, what is WHEN OTHERS Clause in exception handling, WHEN OTHERS Clause in exception handling in oracle plsql

Named Programmer Defined Exceptions in Oracle PLSQL

December 21, 2012 by techhoneyadmin

Oracle PLSQL exception is the condition that terminates the execution of plsql block. Named Programmer Defined Exception:- The named programmer defined exceptions are the plsql exceptions that are defined by a programmer to trap specific exceptions hence have been named. The named programmer defined plsql exceptions are not named in the standard package in plsql […]

Filed Under: plsql Tagged With: EXCEPTIONHandlingPLSQL, how to handle named programmer defined exception in oracle plsql, named programmer defined exception handling in oracle plsql, Oracle plsql named programmer defined exception handling, what is oracle plsql named programmer defined exception handling

Named System Exceptions in Oracle PLSQL

December 21, 2012 by techhoneyadmin

Oracle PLSQL exception is the condition that terminates the execution of plsql block. Named System PLSQL Exceptions:- The named system exceptions are the plsql exception that are encountered frequently and hence have been named for ease of use and that’s why they are called as named system exception. The named plsql exceptions are named in […]

Filed Under: plsql Tagged With: EXCEPTIONHandlingPLSQL, how to handle named system exception in oracle plsql, named system exception handling in oracle plsql, Oracle plsql named system exception handling, what is oracle plsql named system exception handling

Exception Handling in Oracle PLSQL

December 21, 2012 by techhoneyadmin

Oracle PLSQL exception can be termed as a condition that terminates the execution of plsql block. Oracle PLSQL gives us the functionality to handle the exception that can crop up in any Oracle PLSQL block and this functionality is called as Exception Handling. Using plsql exception handling we can avoid the code to end abruptly. […]

Filed Under: plsql Tagged With: exception handling in oracle plsql, EXCEPTIONHandlingPLSQL, how to handle exception in oracle plsql, Oracle plsql exception handling, what is oracle plsql exception handling

Copyright © 2023 · Parallax Pro on Genesis Framework · WordPress · Log in