| Author |
Need help on 1Z0-001 question!
|
|
| sid456 2002-02-08, 6:58 am |
| In which section of a PL/SQL block is a
user-defined exception raised?
a. execution
b. declarative
c. heading
d. exception handling
Your help please! | |
| aneesh_bhatia 2002-02-08, 7:19 am |
| quote:
Originally posted by sid456
In which section of a PL/SQL block is a
user-defined exception raised?
a. execution
b. declarative
c. heading
d. exception handling
Your help please!
D: Exception Handling Section  | |
| metto666 2002-02-08, 8:25 am |
| In which section of a PL/SQL block is a
user-defined exception raised?
The Answer is :
a. execution
Mohamed Metwally | |
| siddharth_k 2002-02-09, 12:58 am |
| i dont think execution is right .. i would go for exception handling | |
|
| The answer is definately a:Execution. | |
| siddharth_k 2002-02-09, 6:51 am |
| i believe exception block lies within execution block now ... its upto you to decide..
the general structure is something like
decln
begin
exception
exception handler
end
...
so its upto you to decide | |
| metto666 2002-02-09, 8:33 am |
| Hello ,
Here is Exception Types :
1- Predefined oracle server error
" Don't Declare and Allow The Oracle server to raise Them Implicitly"
2- Non-Predefined Oracle Server error
"Declare Within The Declarative Section and allow the oracle server to raise them Implicitly"
3- User-Defined Error
"A condition that The Developer Determines is Abnormal, Declare Within The Declarative Section And Raise Explicitly"
EX for The User-Defined Exceptions :
Declare
e_invalid_product Exception;
Begin
..........
Raise e_invalid_product;
Exception
When e_invalid_product THEN ........
End;
So We Raise it in The Execution Section.
Mohamed Metwally | |
| odonata 2002-02-09, 9:27 am |
| Read the Question Carefull - this is a great question!
keywords here is the USER-DEFINED and WHERE it is RAISED.
So, as Ian_j and metto wrote, definitely execution section! | |
| siddharth_k 2002-02-09, 11:00 pm |
| sorry !!! metwally , you are absolutely right. i missed the RAISED part.
thanx for correcting me... |
|
|
|