Oracle/Creating Stored Procedure 썸네일형 리스트형 Creating Stored Procedures try { Statement stmt = connection.createStatement(); // Create procedure myproc with no parameters String procedure = "CREATE OR REPLACE PROCEDURE myproc IS " + "BEGIN " + "INSERT INTO oracle_table VALUES('string 1'); " + "END;"; stmt.executeUpdate(procedure); // Create procedure myprocin with an IN parameter named x. // IN is the default mode for parameter, so both `x VARCHAR' and `x IN VARCHAR.. 더보기 이전 1 2 다음