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

How do you drop an index?

924

---

Can we hide the definition of a stored procedure from a use?

1224

---

What is 3nf normalization?

996

---

What is difference between line feed ( ) and carriage return ( )?

908

---

How to change the ownership of a schema in ms sql server?

1194

---

How do I find my localdb version?

986

---

What is #temp and @table variable in SQL server?

1093

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

922

---

What is BLOCK statements in SQL?

1264

---

How to scale out a federation by Sql statement?

116

---

How to convert a numeric expression from one data type to another?

1016

---

What is indexed view? How to create it?

1009

---

What is sql server programming?

1046

---

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1163

---

Explain what role entity and relationship play in an ER diagram.

1073

---