Call an Oracle package

[Manuel Leiria]

Hi,

I have this Oracle package:

create or replace PACKAGE       "PACK_PRT_ACOMP_COBR" AS
 
TYPE CURSOR_OUT IS REF CURSOR;
 
FUNCTION F_DIA RETURN CURSOR_OUT;
 
FUNCTION F_MAPA RETURN CURSOR_OUT;
 
END PACK_PRT_ACOMP_COBR;
    

and now I want to call the function F_DIA. I'm using this syntax (extracted from some oracle tutorial just to get it working):

public void getF_dia() throws Exception {
Connection conn = oracleDataSource.getConnection();
String jobquery = "begin PRT.PACK_PRT_ACOMP_COBR.F_DIA(?); end;";
      CallableStatement callStmt = conn.prepareCall(jobquery);
      callStmt.registerOutParameter(1, OracleTypes.CURSOR);
      callStmt.execute();
   // return the result set
      ResultSet rset = (ResultSet)callStmt.getObject(1);//it blows up in this line!!
 
    }
 
    

and I'm getting this exception:

  Error 500--Internal Server Error 
java.sql.SQLException: ORA-06550: linha 1, coluna 7:
PLS-00306: n�mero errado ou tipos de argumentos na chamada para 'F_DIA' (wrong number or wrong type of arguments in calling 'F_DIA')
ORA-06550: linha 1, coluna 7:
PL/SQL: Statement ignored
 
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
   

Any ideas?

thnaks in advance,

[Jan Cumps]

String jobquery = "{ ? = PRT.PACK_PRT_ACOMP_COBR.F_DIA() }";

[ May 27, 2008: Message edited by: Jan Cumps ]