Java stored procedures pb

Hi

we are trying to use stored procedures written in java in a Oracle8i database. We followed the steps given inthe documentation (create java procs, load the class files into the database and publish the function).

When the procedures does not use the database (ie only do some calculation), a simple "select funcname(param1,param2) from dual;" works fine but when it needs to acces th database, we always get the message: "ORA-00932: inconsistent datatype" (translation of my own).

There seems to be a problem with the first parameter of the function (java.sql.Connection conn) that is supposed to be affected automatically when the function has been published.

Anyone has an idea?

regards Received on Tue Apr 03 2001 - 09:59:21 CDT