<div>
Have you looked around on the web? &nbsp;Examples are everywhere.<br />
<br />
<a href="http://www.mkyong.com/jdbc/jdbc-callablestatement-stored-procedure-in-parameter-example/" rel="ugc">http://www.mkyong.com/jdbc/jdbc-callablestatement-stored-procedure-in-parameter-example/</a><br />
<br />
<a href="http://www.mkyong.com/jdbc/jdbc-callablestatement-stored-procedure-in-parameter-example/" rel="ugc">http://www.mkyong.com/jdbc/jdbc-callablestatement-stored-procedure-in-parameter-example/</a><br />
<br />
Trapping the error is just like any other call: &nbsp;try/catch.
</div>


Have you looked around on the web?  Examples are everywhere.

http://www.mkyong.com/jdbc/jdbc-callablestatement-stored-procedure-in-parameter-example/ [http://www.mkyong.com/jdbc/jdbc-callablestatement-stored-procedure-in-parameter-example/]

http://www.mkyong.com/jdbc/jdbc-callablestatement-stored-procedure-in-parameter-example/ [http://www.mkyong.com/jdbc/jdbc-callablestatement-stored-procedure-in-parameter-example/]

Trapping the error is just like any other call:  try/catch.

<div>
I am looking for the OUT parameter...<br />
How do I catch a SQLException?<br />
Thanks.
</div>


I am looking for the OUT parameter...
How do I catch a SQLException?
Thanks.

<div>
Thanks guys...Java's just still new to me.<br />
Appreciate it.
</div>


Thanks guys...Java's just still new to me.
Appreciate it.

<div>
<div class="content wysiwyg-content">
Greetings,<br />
<br />
Does anyone have an example where from JAVA, I can call an ORACLE PL/SQL Stored Procedure, then capture the ORACLE output message (success or failure). &nbsp;Basically, what I want to know is if I can call the PL/SQL Stored Procedure, and capture (in JAVA) whether it ran successfully, or not.<br />
<br />
Thank you.
</div>
</div>


Greetings,

Does anyone have an example where from JAVA, I can call an ORACLE PL/SQL Stored Procedure, then capture the ORACLE output message (success or failure).  Basically, what I want to know is if I can call the PL/SQL Stored Procedure, and capture (in JAVA) whether it ran successfully, or not.

Thank you.

JAVA PL/SQL OUTPUT

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.

Oracle Database

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.

Java

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.