/* * This sample shows how to call a PL/SQL stored procedure * using the SQL92 syntax. See also the other sample PLSQL.java. * * note: jdk1.2 is recommanded. jdk1.1 will also work */import java.sql.*;import java.io.*;class PLSQLExample{  public static void main (String args [])       throws SQLException, IOException  {    // Load the driver    DriverManager.registerDriver(new oracle.jdbc.OracleDriver());    String url = "jdbc:oracle:oci8:@";    try {      String url1 = System.getProperty("JDBC_URL");      if (url1 != null)        url = url1;    } catch (Exception e) {      // If there is any security exception, ignore it      // and use the default    }    // Connect to the database    Connection conn =      DriverManager.getConnection (url, "hr", "hr");    // Create a statement    Statement stmt = conn.createStatement ();    // Create the stored function    stmt.execute ("create or replace function RAISESAL"                  + " (name CHAR, raise NUMBER) return NUMBER"                  + " is begin return raise + 100000; end;");    // Close the statement    stmt.close();    // Prepare to call the stored procedure RAISESAL.    // This sample uses the SQL92 syntax    CallableStatement cstmt = conn.prepareCall ("{? = call RAISESAL (?, ?)}");    // Declare that the first ? is a return value of type Int    cstmt.registerOutParameter (1, Types.INTEGER);    // We want to raise LESLIE's salary by 20,000    cstmt.setString (2, "LESLIE");  // The name argument is the second ?    cstmt.setInt (3, 20000);        // The raise argument is the third ?      // Do the raise    cstmt.execute ();    // Get the new salary back    int new_salary = cstmt.getInt (1);    System.out.println ("The new salary is: " + new_salary);    // Close the statement    cstmt.close();    // Close the connection    conn.close();  }}