Create a function named myfuncinout that returns a VARCHAR value; the function has an IN/OUT parameter named x. - Java JDBC

Description

Create a function named myfuncinout that returns a VARCHAR value; the function has an IN/OUT parameter named x.

try {
    function =
        "CREATE OR REPLACE FUNCTION myfuncinout(x IN OUT VARCHAR) RETURN VARCHAR IS "
        + "BEGIN "
        + "x:= x||'outvalue'; "
        + "RETURN 'a returned string'; "
        + "END;";
    stmt.executeUpdate(function);
} catch (SQLException e) {
}

• Previous
• Next

Related Tutorials

• Invoking Stored Procedures
• Stored Procedure Creation and Call for Oracle
• Stored Procedure Creation and Call for MySQL
• 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