Advertisement
Guest User

Untitled

a guest
May 2nd, 2016
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.05 KB | None | 0 0
  1. CREATE OR REPLACE function CUSTOMERAPP.procOneParameter
  2. return boolean
  3. IS
  4. BEGIN
  5.  
  6. return true;
  7.  
  8. END;
  9.  
  10. public class CallFunctionFromOracle {
  11.  
  12. public static void main(String... arg) throws SQLException {
  13. Connection con = null;
  14. CallableStatement callableStmt = null;
  15. try {
  16. // registering Oracle driver class
  17. Class.forName("oracle.jdbc.driver.OracleDriver");
  18.  
  19. // getting connection
  20. con = DriverManager.getConnection(
  21. "jdbc:oracle:thin:@10.11.201.166:1521:xe", "customerapp", "customerapp");
  22.  
  23. System.out.println("Connection established successfully!");
  24.  
  25.  
  26. callableStmt = con.prepareCall("{ ? = call procOneParameter()}");
  27.  
  28. //Database function will return value as OUT parameter
  29. callableStmt.registerOutParameter(1, java.sql.Types.NUMERIC);
  30.  
  31. //IN parameter -
  32. //set methods are used for setting IN parameter values of Stored procedure
  33. // callableStmt.setInt(2, 11);
  34.  
  35. //Execute database Function,
  36. callableStmt.execute();
  37.  
  38. // Then retrieve values returned by method using using get methods.
  39. System.out.println("salary = " + callableStmt.getBoolean(1));
  40.  
  41. System.out.println("Function executed successfully, "
  42. + "salary has been fetched from Employee table");
  43.  
  44. } catch (ClassNotFoundException e) {
  45. e.printStackTrace();
  46. } catch (SQLException e) {
  47. e.printStackTrace();
  48. }
  49. finally{
  50. try {
  51. if(callableStmt!=null) callableStmt.close(); //close CallableStatement
  52. if(con!=null) con.close(); // close connection
  53. } catch (SQLException e) {
  54. e.printStackTrace();
  55. }
  56. }
  57. }
  58.  
  59. }
  60.  
  61. java.sql.SQLException: ORA-06550: line 1, column 13:
  62. PLS-00382: expression is of wrong type
  63. ORA-06550: line 1, column 7:
  64. PL/SQL: Statement ignored
  65.  
  66. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
  67. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
  68. at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
  69. at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
  70. at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
  71. at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
  72. at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:204)
  73. at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1007)
  74. at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
  75. at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
  76. at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3677)
  77. at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4714)
  78. at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
  79. at callfunctionfromoracle.CallFunctionFromOracle.main(CallFunctionFromOracle.java:44)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement