How to capture the error message returned from the procedure and printit out.

[renu]

Hi

I am working on a project , where i will call a procedure passing some information to the procedures parameters.
If the procedure doesnot receive the right parameter values ..it displays an error message .

How to capture the error message and print it out to the screen .

CallableStatement proc_stmt;
			try {
				proc_stmt = connection.prepareCall("{? = call PKG_COMPARE.F_2_SCHOOL(?,?,?)}");	
//				Register the type of the return value		
				proc_stmt.registerOutParameter(1,OracleTypes.CURSOR);			   
				proc_stmt.setInt(2,year);
				proc_stmt.setString(3,schoolname);			                         proc_stmt.setString(4, version1);
							
//              Execute and retrieve the returned value
				proc_stmt.execute();
				ResultSet rs = (ResultSet) proc_stmt.getObject(1); // 
?????-----> WHAT CODE I NEED TO WRITE TO CAPTURE THE ERROR RETURNED FROM THE PROCEDURE ????

Thanks in advance .

[Zack]

Here's a basic bit on exceptions: Lesson: Exceptions (The Java™ Tutorials > Essential Classes)

Here's how to get the error message: http://download.oracle.com/javase/6/...l#getMessage()
...and you will find other helpful links in that page also.

Best of luck!

[renu]

thank all again ....