import java.sql.*;

public class book

{

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

{

// initialize the driver and try to make a connection

DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver ( ));

Connection conn =

DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:o92",

"scott", "tiger");

// prepareCall uses ANSI92 "call" syntax

CallableStatement cstmt = conn.prepareCall("{? = call booktitle(?)}");

// get those bind variables and parameters set up

cstmt.registerOutParameter(1, Types.VARCHAR);

cstmt.setString(2, "0-596-00180-0");

// now we can do it, get it, close it, and print it

cstmt.executeUpdate( );

String bookTitle = cstmt.getString(1);

conn.close( );

System.out.println(bookTitle);

}

}

/*======================================================================

| Supplement to the fifth edition of Oracle PL/SQL Programming by Steven

| Feuerstein with Bill Pribyl, Copyright (c) 1997-2009 O'Reilly Media, Inc.

| To submit corrections or find more code samples visit

| http://oreilly.com/catalog/9780596514464/

*/