01.package com.java.myapp;
02.
03.import java.sql.CallableStatement;
04.import java.sql.Connection;
05.import java.sql.DriverManager;
06.import java.sql.ResultSet;
07.import java.sql.SQLException;
08.import java.sql.Types;
09.
10.import oracle.jdbc.OracleTypes;
11.
12.public class MyClass {
13. public static void main(String[] args) {
14.
15. Connection connect = null;
16.
17. try {
18.
19. Class.forName("oracle.jdbc.driver.OracleDriver");
20. connect = DriverManager.getConnection("" +
21. "jdbc:oracle:thin:@//localhost:1521/tcdb", "myuser","mypassword");
22.
23.
24. String command = "{CALL INSERT_CUSTOMER(?,?,?,?,?,?,?,?)}";
25. CallableStatement stmt = connect.prepareCall (command);
26.
27.
28. String strCustomerID = "C005";
29. String strName = "Fun Wipa";
30. String strEmail = "fun.wipa@thaicreate.com";
31. String strCountryCode = "TH";
32. Double dBudget = 100000.00;
33. Double dUsed = 0.00;
34.
35. stmt.setString(1, strCustomerID);
36. stmt.setString(2, strName);
37. stmt.setString(3, strEmail);
38. stmt.setString(4, strCountryCode);
39. stmt.setDouble(5, dBudget);
40. stmt.setDouble(6, dUsed);
41. stmt.registerOutParameter(7, OracleTypes.INTEGER);
42. stmt.registerOutParameter(8, OracleTypes.VARCHAR);
43.
44.
45. stmt.execute();
46.
47.
48. Integer pResult = stmt.getInt(7);
49. System.out.println("pResult : " + pResult.toString());
50.
51.
52. String pMessage = stmt.getString(8);
53. System.out.println("pMessage : " + pMessage);
54.
55. } catch (Exception e) {
56.
57. e.printStackTrace();
58. }
59.
60. try {
61. connect.close();
62. } catch (SQLException e) {
63.
64. e.printStackTrace();
65. }
66. }
67.}
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน 
