Hello,

I need call an oracle sql function that has this header:

CREATE OR REPLACE PACKAGE ARMADO.COP IS
FUNCTION FNC_SECUENCIA( NUM_CONCESIONARIA IN NUMBER , NOMBRE_SECUENCIA IN VARCHAR2) RETURN NUMBER ;
END;

I have this in my java code:

try
{
SessionFactory sessionFactory = HibernateUtil.getSessionFactory();
session = sessionFactory.openSession();
session.beginTransaction();
int result = session.createSQLQuery("{ ? = call ARMADO.COP.FNC_SECUENCIA(?,?)}")
.setParameter(0,3)
.setParameter(1,"NUM_CORR_VIAJE")
.executeUpdate();
}
catch(Exception ex)
{
logger.error("Error : " + ex);
}

But i get this exception: could not execute native bulk manipulation query.

Anyone has any idea???
Thaks in advance.

Hi mtigua

Iam also facing same problem.iam new to hibernate.Will u please give me anu suggestions on Calling a simple function using hibernate.These are my steps i followed if any worng please let me know.

Step 1) Created a simple funtion
CREATE OR REPLACE FUNCTION simple RETURN VARCHAR2 IS
BEGIN
RETURN 'Simple Function';
END simple;

Step 2) In hibernate Mapping File

<hibernate-mapping>
<class name="Writer1" table="WRITER1" >
<id name="id" >
<column name="ID" />
<generator class="increment" />
</id>
<property name="name" >
<column name="NAME" />
</property>

<sql-query name="createJob" callable= "true">
<return-scalar column="PASS" type="String"/>
{ ? = call createJob() }
</sql-query>

</class>

</hibernate-mapping>

Step 3) Im Main Program

Query namedQuery = session.getNamedQuery("createJob");

String Pass = (String)namedQuery.uniqueResult();

System.out.println("Calling Stored Proc "+Pass);


Is any thing worng here,actually iam facing error over here

Sorry for wrong printing

Over Hiberbate MappingFile

<sql-query name="createJob" callable= "true">
<return-scalar column="PASS" type="String"/>
{ ? = call simple() } //In the previous one it is CreateJob
</sql-query>