Create a function named myfuncin which returns a VARCHAR value - Java JDBC

Description

Create a function named myfuncin which returns a VARCHAR value

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 function =//from www .j a v  a 2 s .c  om
        "CREATE OR REPLACE FUNCTION myfuncout(x OUT VARCHAR) RETURN VARCHAR IS "
        + "BEGIN "
        + "x:= 'outvalue'; "
        + "RETURN 'a returned string'; "
        + "END;";
    stmt.executeUpdate(function);
  }
}

• Previous
• Next

Related Tutorials

• Stored Procedure Creation and Call for Oracle
• Stored Procedure Creation and Call for MySQL
• Create a function named myfuncinout that returns a VARCHAR value; the function has an IN/OUT parameter named x.
• 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