Error returning REF CURSOR

From: Dom (dom_at_nospam.it)
Date: 02/17/05 

Date: Thu, 17 Feb 2005 16:36:46 GMT

Hello,
I'm trying to invoke a PLSQL function returning a REF CURSOR

I'm using OracleCallableStatement .... and this is the code:
=================CODE=======================
Connection conn = null;
OracleCallableStatement oraCallStmt = null;
OracleResultSet oraResultSet = null;

oraCallStmt = (OracleCallableStatement) conn.prepareCall(
                "{? = call java_refcursor.account_listing(?,?)}" );
oraCallStmt.registerOutParameter(1, OracleTypes.CURSOR);
String username="007nino"; String domain="blu.it";
oraCallStmt.setString(2, username);
oraCallStmt.setString(3, domain);
System.out.println(oraCallStmt.execute());
oraResultSet = (OracleResultSet)oraCallStmt.getCursor(1);
=================CODE=======================

I obtain the following error:
=================ERROR=======================
false
java.lang.UnsatisfiedLinkError: make_statement
at oracle.jdbc.oci8.OCIDBAccess.make_statement(Native Method)
at
oracle.jdbc.oci8.OCIDBAccess.RefCursorBytesToDBStatement(OCIDBAccess.java:24
19)
at
oracle.jdbc.driver.OracleStatement.getCursorValue(OracleStatement.java:3836)
at
oracle.jdbc.driver.OracleCallableStatement.getCursor(OracleCallableStatement
.java:793)
at it.wind.crm.test.TestRefCursor.main(TestRefCursor.java:39)
Exception in thread "main"
=================ERROR=======================

and this is the plsql code:

=================CODE=======================
CREATE OR REPLACE package java_refcursor as
    type myrctype is ref cursor;

    function account_listing (usr varchar2, dom varchar2) return myrctype;

end java_refcursor;
/

CREATE OR REPLACE package body java_refcursor as
    function account_listing (usr varchar2, dom varchar2) return myrctype
       is
        rc myrctype;
    begin
        open rc for select * from ACCOUNT where username=usr and domain=dom;
        return rc;
    end;
  end java_refcursor;
/
=================CODE=======================

I wonder what's wrong....

thanks for any help
Dom