Discussions

General J2EE: Details Needed for Using Java Stored Procedure

  1. Details Needed for Using Java Stored Procedure (3 messages)

    AnyBody,Provide how to use Java Stored Procedure in Oracle Database.

    Threaded Messages (3)

  2. CallableStatement[ Go to top ]

    try{ int age = 39; String poetName = "Ashok Srinivasan"; CallableStatement proc = connection.prepareCall("{ call set_death_age(?, ?) }"); proc.setString(1, poetName); proc.setInt(2, age); cs.execute(); }catch (SQLException e){ // ....}
  3. Re: CallableStatement[ Go to top ]

    Thats pretty right. You use callable statement to call stored proc..
  4. Thanks For Your Reply. I have done the Mistake in giving the Subject and Message actually. My Actual Question is: Details Needed for Storing the Java Class in Oracle Database as Object and accessing the methods through Oracle SQL or PL/SQL..