<div>
<div class="content wysiwyg-content">
In my database I have an Oracle database table &quot;Sports&quot;. One of the columns in this table will contain the names of different &nbsp;Sports teams.<br />
<br />
I also have a stored procedure. One of the parameters in this stored procedure will be called &quot;TeamName&quot;. The stored procedure<br />
will search the Sports Table &nbsp;to see &nbsp;if it contains the value store stored in the TeamNam parameter.<br />
<br />
If and when the team name is not found the Oracle SP with throw an exception. So is there a way for me to prevent and exception from being thrown, because I just want the stored procedure to gracefully recover if an exception occurs?
</div>
</div>


In my database I have an Oracle database table "Sports". One of the columns in this table will contain the names of different  Sports teams.

I also have a stored procedure. One of the parameters in this stored procedure will be called "TeamName". The stored procedure
will search the Sports Table  to see  if it contains the value store stored in the TeamNam parameter.

If and when the team name is not found the Oracle SP with throw an exception. So is there a way for me to prevent and exception from being thrown, because I just want the stored procedure to gracefully recover if an exception occurs?

How to Gracefuly recover in Racle stored procedure

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.