What is an Exception ? What are types of Exception ?

What is an Exception ? What are types of Exception ?
by

1 Answer

Answer :

Exception is the error handling part of PL/SQL block. The types are
Predefined and user defined. Some of Predefined exceptions are.
CURSOR_ALREADY_OPEN
DUP_VAL_ON_INDEX
NO_DATA_FOUND
TOO_MANY_ROWS
INVALID_CURSOR
INVALID_NUMBER
LOGON_DENIED
NOT_LOGGED_ON
PROGRAM-ERROR
STORAGE_ERROR
TIMEOUT_ON_RESOURCE
VALUE_ERROR
ZERO_DIVIDE
OTHERS.
by

Related questions

What is a predefined exception available in forms 4.0?

Description : What is a predefined exception available in forms 4.0?

Last Answer : Raise form_trigger_failure

What are the types of visual attribute settings?

Description : What are the types of visual attribute settings?

Last Answer : Custom Visual attributes Default visual attributes Named Visual attributes. Window

What are the types of SQL Statement ?

Description : What are the types of SQL Statement ?

Last Answer : Data Definition Language : CREATE,ALTER,DROP,TRUNCATE,REVOKE,NO AUDIT & COMMIT.

How many types of Exceptions are there

Description : How many types of Exceptions are there

Last Answer : There are 2 types of exceptions. They are a) System Exceptions e.g. When no_data_found, When too_many_rows b) User Defined Exceptions e.g. My_exception exception When My_exception then

Give the two types of tables involved in producing a star schema and the type of data they hold.

Description : Give the two types of tables involved in producing a star schema and the type of data they hold.

Last Answer : Fact tables and dimension tables. A fact table contains measurements while dimension tables will contain data that will help describe the fact tables.

What are the different types of segments?

Description : What are the different types of segments?

Last Answer : Data segment, index segment, rollback segment and temporary segment.

What are the types of database links?

Description : What are the types of database links?

Last Answer : Private database link, public database link & network database link.

How many types of columns are there and what are they

Description : How many types of columns are there and what are they

Last Answer : Formula columns :: For doing mathematical calculations and returning one value Summary Columns :: For doing summary calculations such as summations etc. Place holder Columns :: These columns are useful for storing the value in a variable

What r the types of windows (Window style)?

Description : What r the types of windows (Window style)?

Last Answer : Specifies whether the window is a Document window or a Dialog window.

How many types of canvases are there.

Description : How many types of canvases are there.

Last Answer : There are 2 types of canvases called as Content and Stack Canvas. Content canvas is the default and the one that is used mostly for giving the base effect. Its like a plate on which we add items and stacked canvas is used for giving 3 dimensional effect.

What are the types of triggers and how the sequence of firing in text item

Description : What are the types of triggers and how the sequence of firing in text item

Last Answer : Triggers can be classified as Key Triggers, Mouse Triggers ,Navigational Triggers. Key Triggers :: Key Triggers are fired as a result of Key action.e.g :: Key-next-field, Key-up,Key-Down Mouse Triggers :: Mouse ... :: a) pre - text b) when new item c) key-next d) when validate e) post text

How many types of Sql Statements are there in Oracle

Description : How many types of Sql Statements are there in Oracle

Last Answer : There are basically 6 types of sql statments.They are a) Data Defination Language(DDL) :: The DDL statments define and maintain objects and drop objects. b) Data Manipulation Language(DML) :: The DML ... e.g:: Using the Sql Statements in languages such as 'C', Open,Fetch, execute and close

What are the different types of Coordinations of the Master with the Detail block?

Description : What are the different types of Coordinations of the Master with the Detail block?

Last Answer : POPULATE_GROUP(function) POPULATE_GROUP_WITH_QUERY(function) SET_GROUP_CHAR_CELL(procedure) SET_GROUPCELL(procedure) SET_GROUP_NUMBER_CELL(procedure)

What are the data types allowed in a table ?

Description : What are the data types allowed in a table ?

Last Answer : CHAR,VARCHAR2,NUMBER,DATE,RAW,LONG and LONG RAW.

What is a join ? Explain the different types of joins ?

Description : What is a join ? Explain the different types of joins ?

Last Answer : Join is a query which retrieves related columns or rows from multiple tables.Self Join - Joining the table with itself.Equi Join - Joining two tables by equating two common columns.Non-Equi Join - ... that query can also retrieve rows that do not have corresponding join value in the other table.

What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Description : What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Last Answer : Procedures and Functions,Packages and Database Triggers.

How many types of database triggers can be specified on a table ? What are they ?

Description : How many types of database triggers can be specified on a table ? What are they ?

Last Answer : Insert Update Delete Before Row o.k. o.k. o.k. After Row o.k. o.k. o.k. Before Statement o.k. o.k. o.k. After Statement o.k. o.k. o.k. If FOR EACH ROW clause is ... for each Row affected by the statement. If WHEN clause is specified, the trigger fires according to the returned Boolean value.

Explain types of Block in forms4.0?

Description : Explain types of Block in forms4.0?

Last Answer : Base table Blocks. Control Blocks. 1. A base table block is one that is associated with a specific database table or view. 2. A control block is a block that is not associated with a database table. ITEMS

What are the types of canvas-views?

Description : What are the types of canvas-views?

Last Answer : Content View, Stacked View.

Give the Types of modules in a form?

Description : Give the Types of modules in a form?

Last Answer : Form Menu Library

What are the different types of windows?

Description : What are the different types of windows?

Last Answer : Root window, secondary window.

List the Types of Items?

Description : List the Types of Items?

Last Answer : Text item. Chart item. Check box. Display item. Image item. List item. Radio Group. User Area item.

What are the types of TRIGGERS ?

Description : What are the types of TRIGGERS ?

Last Answer : 1. Navigational Triggers. 2. Transaction Triggers.

What are the different types of Package Procedure ?

Description : What are the different types of Package Procedure ?

Last Answer : 1. Restricted package procedure. 2. Unrestricted package procedure.

What are the different types of key triggers ?

Description : What are the different types of key triggers ?

Last Answer : Function Key Key-function Key-others Key-startup

What are the types of Pop-up window ?

Description : What are the types of Pop-up window ?

Last Answer : the pop-up field editor pop-up list of values pop-up pages. Alert :

What are different types of images?

Description : What are different types of images?

Last Answer : Boiler plate imagesImage Items

What are the different types of Delete details we can establish in Master-Details?

Description : What are the different types of Delete details we can establish in Master-Details?

Last Answer : Cascade Isolate Non-isolate

What are the different types of Delete details we can establish in Master-Details?

Description : What are the different types of Delete details we can establish in Master-Details?

Last Answer : Content canvas views Stacked canvas views Horizontal toolbar vertical toolbar.

What are different types of modules available in oracle form?

Description : What are different types of modules available in oracle form?

Last Answer : Form module - a collection of objects and code routines Menu modules - a collection of menus and menu item commands that together make up an application menu library module - a collection of user named procedures, functions and packages that can be called from other modules in the application

What are the three types of user exits available ?

Description : What are the three types of user exits available ?

Last Answer : Oracle Precompiler exits, Oracle call interface, NonOracle user exits.

What are the different types of Record Groups?

Description : What are the different types of Record Groups?

Last Answer : Query Record Groups NonQuery Record Groups State Record Groups

What are the types of calculated columns available?

Description : What are the types of calculated columns available?

Last Answer : Summary, Formula, Placeholder column.

What are the different Parameter types?

Description : What are the different Parameter types?

Last Answer : Text ParametersData Parameters

What are Most Common types of Complex master-detail relationships?

Description : What are Most Common types of Complex master-detail relationships?

Last Answer : There are three most common types of complex master-detail relationships: master with dependent details master with independent details detail with two masters

What are the two types of views available in the object navigator(specific to report 2.5)?

Description : What are the two types of views available in the object navigator(specific to report 2.5)?

Last Answer : View by structure and view by type .

What are the types of synonyms?

Description : What are the types of synonyms?

Last Answer : There are two types of synonyms private and public.

VALUE SET LIST TYPES

Description : VALUE SET LIST TYPES

Last Answer :  List of values (10 to 200)  Long list of values (> 200)  Poplist (> 10)

TYPES OF FLEXFIELD QUALIFIER

Description : TYPES OF FLEXFIELD QUALIFIER

Last Answer : NATURAL ACCOUNT: Each Accounting Flexfield structure must contain only one natural account segment. When setting up the values, you will indicate the type of account as Asset, Liability, Owner's Equity, ... of books. This segment has the same value set and the same values as the balancing segment.

WHAT ARE THE TYPES OF FLEXFIELDS?

Description : WHAT ARE THE TYPES OF FLEXFIELDS?

Last Answer : - Key flexfield - Descriptive flexfield

What are the different plan types available in Fusion Absence Management? Accrual

Description : What are the different plan types available in Fusion Absence Management?

Last Answer : There are three different plan types available in Fusion Absence Management, which are given below: Accrual Use this type to create absence plans that enable workers to accrue time for the ... plan to pay workers if they are not eligible for a standard maternity absence qualification plan.

What are the different types of JOIN operations?

Description : What are the different types of JOIN operations?

Last Answer : Equi Join: This is the most common type of join which involves only equality comparisions. The disadvantage in this type of join is that there

Four Types of Exports:

Description : Four Types of Exports:

Last Answer : 1. Full Database Export 2. Schema Export 3. Table Export 4. Tablespace Export

Name the seven types of Oracle tables

Description : Name the seven types of Oracle tables

Last Answer : Heap Organized Tables, Index Organized Tables, Index Clustered Tables, Hash Clustered Tables, Nested Tables, Global Temporary Tables, Object Tables.

Why do many people hate on excellence and claim that, without exception, the elevated cost is created artificially for vanity alone?

Description : Why do many people hate on excellence and claim that, without exception, the elevated cost is created artificially for vanity alone?

Last Answer : answer:Do they? Is this a thing? I could take a stab at this, but it would be from a different angle. Some people might see a $1.5M price tag and chuckle - not because they don't think ... data. Instead, it's shit animated graphics and designed for people who apparently do not care about the data.

Are all vegetables' sprouts safe to eat or is/are there exception/s?

Description : Are all vegetables' sprouts safe to eat or is/are there exception/s?

Last Answer : answer:Not that I’m aware of unless sprouted in a toxic environment. You could always google each seed you want to sprout individually if you were concerned but seeing as all the sprouts we eat we also eat either in plant form and/or in seed form I would be very surprised.

I was perusing my Questions For You and had 30 odd. I went in to read one question and when I went back to my Questions For You they were all gone with the exception of one. What happened?

Description : I was perusing my Questions For You and had 30 odd. I went in to read one question and when I went back to my Questions For You they were all gone with the exception of one. What happened?

Last Answer : answer:The last one. I deleted all your questions @tranquilsea. Actually, when questions reach a certain number of answers they drop out of the Questions for You' section. It seems to happen at this ... , but I have asked @augustlan about this myself. Off to delete other people's questions now :D

If you were forced to eliminate every physical possession from your life with the exception of what could fit into a single backpack, what would you put in it?

Description : If you were forced to eliminate every physical possession from your life with the exception of what could fit into a single backpack, what would you put in it?

Last Answer : Laptop, hunting knife, flask, a blanket and a change of clean clothes.

How can I alphanumerically sort data in Excel with an exception?

Description : How can I alphanumerically sort data in Excel with an exception?

Last Answer : answer:Under the Sort & Filter options there should be a Custom Sort item. Go to that, then in the resulting window, click the down arrow under Order . There should be a Custom List item. In that ... items in alphabetic order, but then put PT at the top. Let me know if that works out for you.

Shouldn't it be mandatory that Congress and the Senate fully participate in any Health Care System they deliver to the American public without exception?

Description : Shouldn't it be mandatory that Congress and the Senate fully participate in any Health Care System they deliver to the American public without exception?

Last Answer : I’d rather turn this around and say, shouldn’t the entire American public be entitled to the same level of coverage and care that is provided to Congress? After all it is a Government Program. If they don’t dread it for themselves, why do they dread it for us?