Create procedure myprocinout with an IN/OUT parameter named x - Java JDBC

Description

Create procedure myprocinout with an IN/OUT parameter named x

Demo Code

import java.sql.Connection;
import java.sql.Statement;

public class Main {
  public static void main(String[] args) throws Exception{
    Connection connection = null;
    Statement stmt = connection.createStatement();

    String procedure =/*from ww  w.  jav a  2 s  .  c o m*/
        "CREATE OR REPLACE PROCEDURE myprocinout(x IN OUT VARCHAR) IS "
        + "BEGIN "
        + "INSERT INTO oracle_table VALUES(x); " // Use x as IN parameter
        + "x := 'outvalue'; "                    // Use x as OUT parameter
        + "END;";
    stmt.executeUpdate(procedure);

  }
}

• Previous
• Next

Related Tutorials

• Create a function named myfuncin which returns a VARCHAR value
• Create a function named myfuncin which returns a VARCHAR value; the function has an IN parameter named x
• Create a function named myfunc which returns a VARCHAR value; the function has no parameter
• Create procedure myprocout with an OUT parameter named x
• Create procedure myprocin with an IN parameter named x. IN is the default mode for parameter