Answer Posted / shai

Follow best practice for exceptions:

Try using: (available from 10g)

1. dbms_utility.format_error_backtrace
2. dbms_utility.format_error_stack

Example:

declare
x varchar2(10);
begin
select 15445454545 into x from dual;
exception
when others then
dbms_output.put_line
(dbms_utility.format_error_backtrace || ' ' ||
dbms_utility.format_error_stack);
end;

what are tables and fields? : Sql dba

1056

---

Enlist some predefined exceptions?

1060

---

What are different types of statements supported by sql?

1165

---

Can I learn sql in a week?

1076

---

Can I call a procedure inside a function?

1012

---

Explain architecture of sql server notification services?

1061

---

what is a join? : Sql dba

1037

---

what are the security recommendations while using mysql? : Sql dba

1119

---

what are the differences between char and nchar? : Sql dba

1115

---

what is the difference between char_length and length? : Sql dba

1045

---

what are the different type of normalization? : Sql dba

1027

---

Is json a nosql?

982

---

Why do you partition data?

1022

---

What are sql constraints?

1175

---

Is sql dba a good career? : SQL DBA

992

---