0 Replies Latest reply on Feb 4, 2005 11:25 PM by Vinaydath Shivaprasad

    Callable Statetment issue

    Vinaydath Shivaprasad Newbie

      Hi ,
      I have the following piece of code:

      cstmt.registerOutParameter(4, java.sql.Types.OTHER);

      This is used to call a package on Oracle8.1.7. When i run this code, it gives the below error. The package is returning a result set. Also i have noticied a lot of place where if i use .setObject() for any prepared statement, it gives me a similar error.
      Can anyone please throw some light on this.

      I am using a Jboss3.2.1 and JDK1.3. This is for porting from WL7.0SP2 to Jboss. This code works fine in WL.

      Thanks

      09:40:43,453 ERROR [STDERR] java.sql.SQLException: Invalid column type