title: Pl/sql %RowType in JDBC
body: <p>I have been trying to execute a Oracle Stored procedure  which returns %ROWTYPE using JDBC, as i mentioned below</p>
  
  <pre><code>  OracleCallableStatement ocs = (OracleCallableStatement)conn.prepareCall("begin &lt;PackageName&gt;.procedureName(?,?,?,?); end; ");
    ocs.setString(1, "001");
    ocs.registerOutParameter(2,java.sql.Types.VARCHAR);
    ocs.registerOutParameter(3,java.sql.Types.VARCHAR);
    ***ocs.registerOutParameter(4,java.sql.Types.OTHER);*** /*here What do i need to put, i didn't find Wrapperclass which is compatible for %ROWTYPE*/
  
   ocs.executeUpdate(); 
  
   String newerrorcode =  ocs.getString(2);
  
  System.out.println("\n ErrorCode = " + newerrorcode );
  String newErrorDesc =  ocs.getString(3);
  
  System.out.println("\n ErrorDesc = " + newErrorDesc );
  ResultSet rs = (ResultSet) ocs.getObject(4);
  </code></pre>
  
  <p>exception: that we are getting is as follows</p>
  
  <pre><code>Exception in thread "main" java.sql.SQLException: ORA-06550: line 1, column 7:
  PLS-00306: wrong number or types of arguments in call to 'PR_APP_DATE'
  ORA-06550: line 1, column 7:
  PL/SQL: Statement ignored
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
  at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
  at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3530)
  at oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:4735)
  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
  at testSysBusinessDts.main(testSysBusinessDts.java:62)
  </code></pre>