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 is the difference between python and sql?

938

---

What is duration in sql profiler trace?

1020

---

How do you update sql?

912

---

what are the performance and scalability characteristics of mysql? : Sql dba

942

---

What does where 1 1 mean in sql?

978

---

What is a composite primary key?

1030

---

What is the importance of sqlcode and sqlerrm?

1276

---

How to assign sql query results to pl sql variables?

991

---

How do you update a sql procedure?

970

---

What are the qualities of 2nf?

975

---

Can you join a table to itself?

1029

---

How sql query is executed?

1065

---

what is a view? : Sql dba

1026

---

What is the use of partition by in sql?

928

---

What is oracle sql developer?

992

---