Answer Posted / saraswathi muthuraman

If the procedure execution fails the oracle will quit the
execution with an error.

This error can be handled with in store procedure using
"exception".

declare
test_excep_name exception;
x number;
Begin
select emp_no into x from emp_test where emp_no=1;
If SQL%NOTFOUND then
raise test_excep_name;
end if;

exception
when test_excep_name then
dbms_output.put_line(' Error occurred during execution' || '
SQL error code is ' || sqlcode || ' SQL error maessage '||
sqlerrm);
when others then
dbms_output.put_line(' Error occurred during execution- This
is unknown error ' || ' SQL error code is ' || sqlcode || '
SQL error maessage '|| sqlerrm);
end;
/

Result :

Error occurred during execution- This is unknown error SQL
error code is 100
SQL error maessage ORA-01403: no data found

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

992

---

How to delete an existing row with delete statements in ms sql server?

1029

---

How to modify the underlying query of an existing view?

941

---

What happens if null values are involved in arithmetic operations?

969

---

Why would you use sql agent?

1228

---

Tell me what are the advantages of using stored procedures?

955

---

What are transactions in sql?

993

---

Explain the difference between function and stored procedure?

904

---

Explain mixed authentication mode of sql server?

993

---

What is isnull() operator?

981

---

What are the types of indexing?

1036

---

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

2033

---

How to delete an existing database user?

977

---

What are the different authentication modes in sql server? How can it be changed?

1031

---

What types of replication are supported in sql server?

1010

---