// ******************************************************************
// * File    : excep_2.java
// * Author  : Peter Crompton
// * Date    : 16th October 2000
// *
// * Purpose  : Exception Processing example
// *
// ******************************************************************

import java.sql.*;
import oracle.jdbc.driver.*;

class excep_2
{
public static void main (String args [])
throws SQLException
{

// Load the Oracle JDBC driver
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
String url = "jdbc:oracle:thin:pc/pc@127.0.0.1:1521:pc" ;
Connection conn = DriverManager.getConnection( url );

// Create Oracle DatabaseMetaData object
DatabaseMetaData meta = conn.getMetaData ();

// gets driver info:
System.out.println("JDBC driver version is " + meta.getDriverVersion());

// Call an Oracle function
String call_sf_str = "{? = call SF_12(?) }" ;

try {
  CallableStatement stmt = conn.prepareCall(call_sf_str) ;
  stmt.setInt(2,2) ;
  stmt.registerOutParameter(1,Types.NUMERIC) ;
  stmt.executeUpdate() ;

  int    v1 = stmt.getInt(1) ;

  System.out.println( "v1 = " + v1 ) ;

    } catch( SQLException ex ) {
		while (ex != null) {
		System.out.println("SQLException : " + ex.getMessage());
        System.out.println("SQLState     : " + ex.getSQLState()) ;
        System.out.println("ErrorCode    : " + ex.getErrorCode()) ;
        ex = ex.getNextException() ;
        System.out.println(" ----------------------------------- " ) ;
						   }}

// Close the connection
conn.close() ;
}
}