How to call Oracle stored procedure from Java?

[parag_narkhede]

Hello All,

I want to call one stored procedure from Java. I have written following code. But its not able to make connection to server where Database is running.

 try
      {
  DriverManager.registerDriver (new oracle.jdbc.OracleDriver());
  Connection conn = DriverManager.getConnection ("jdbc:oracle:thin:@192.168.100.148:1526:VIS1", "apps", "apps");
  CallableStatement  cstmt        = null;
  cstmt = conn.prepareCall("Begin myproc(:1); End;");
  cstmt.setString(1,dis.readLine());
  cstmt.execute();
      }
catch (SQLException ex) 
      {
        System.out.println("Failed to establish a connection to: ");
      }
 }

Regards,
Parag

[masijade]

It would help if you actually posted what exception you got.

[parag_narkhede]

Its going in SQLException which I handles and showing

"Failed to establish a connection to:

Process exited with exit code 0."

[masijade]

Yes, I know that from looking at the code. I want to know what exception you are getting. Add an ex.printStackTrace() to that catch block.

[parag_narkhede]

Great...

ex.printStackTrace() showed me error as "Invalid number". I found that in a procedure I am inserting character value in Number column.


Problem is solved. I am new to Java. Now I will read exceptions properly.

Thanks a lot.