In a package have predefined exception and user defined exception. while execution which exception will be executed first? why?
Answer / swati kapoor
User Defined exceptions are executed prior to system
defined exceptions.
User defined exceptions are executed in the order in which
they are defined.
When an exception is raised,normal execution of your PL/SQL
block or subprograms stops and control transfers to its
exception-handling part.
Note: When others should be handle in last of exception
handling part of block.
Is This Answer Correct ? | 6 Yes | 1 No |
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
How to call oracle database stored procedure from form in form coding ?
What is multoorg and what is it's level or structure
Stored procedure?
In SQL Loader i have 100 Records to be loaded into my table. How do i load the first 30 Records and skip the last 10 Records within a single .ctl file ? So my total no.of records to be loaded would be 60. Could anybody help me in this ?
in interface and conversion if 10 records are error out we can't load the records?if >10 we have to insert,if we not insert we need to gernerate error how u can achieve?
can we get profile values in report without using user exists is it possible how?
what are the tables of auto invoice.
what is the difference between credit memo and debit memo?...
1) why we need to do Validations when the Standard Conc. Prog or the API will do all the validations 2) How can we display more then 1 column data in a formula column (Ex displaying Empno, Ename, sal data in one Formula column) 3) is it possible to give 2 out paramaters in a function
In hierarchical structure of a database? we have write query from where we should start?
List the various types of value set.