Oracle java function getting ora-00932

From: Edward A Thompson <ed4becky_2000_at_yahoo.com>
Date: 1 Oct 2004 05:31:37 -0700
Message-ID: <d913df37.0410010431.409d51e3@posting.google.com>

I am having a problem with a Java Function in Oracle 9i.

The following gives me an ORA-00932 inconsistent data types, expected IN conversion failed:

select *
from table(dbo.sampler.getPopSetTypeResults(920000000000548,to_date('20040101','YYYYMMDD')))

The function definition is:     

      FUNCTION getPopSetTypeResults (hospId IN NUMBER, monYear IN DATE) RETURN jPopSetTypeResultArray

        AS LANGUAGE java
      name 'premierinc.sampling.OraPopSetTypes.getResults(long,
java.sql.Date) return oracle.sql.ARRAY';
      

And the java definition is:

    public static oracle.sql.ARRAY getResults(long hospId, java.sql.Date monYear)

        throws SQLException, ClassNotFoundException     {

        me.add(new Long(hospId),me.facilitiesSet);
        return getResults(me, monYear);

    }          

I don't see the problem.

Help?! Received on Fri Oct 01 2004 - 07:31:37 CDT