Oracle Procedure:
CREATE OR REPLACE
PROCEDURE INSERT_ROW_PROC AS
BEGIN
insert into slc_message(message_id, subject, message) values(41,'insert row','insert row');
END INSERT_ROW_PROC;
Hibernate mapping:
<hibernate-mapping>
<class name="com.citi.gcgna.cdf.slc.presentation.jfp.borrower.subapps.messages.dao.MessageSP">
<id name="messageId" type="long" />
<property name="subject" type="java.lang.String" />
<property name="message" type="java.lang.String" />
</class>
<sql-query name="insert_SP" callable="true">
<return alias="mess" class="com.citi.gcgna.cdf.slc.presentation.jfp.borrower.subapps.messages.dao.MessageSP">
</return>
{ call INSERT_ROW_PROC() }
</sql-query>
</hibernate-mapping>
Calling Code:
Query q = session.getNamedQuery("insert_SP");
q.list();
I am getting ERROR org.hibernate.util.JDBCExceptionReporter - Invalid column index and could not execute query message.
Could you please help me to solve this issue?
Thanks,
Durgha Prasad
CREATE OR REPLACE
PROCEDURE INSERT_ROW_PROC AS
BEGIN
insert into slc_message(message_id, subject, message) values(41,'insert row','insert row');
END INSERT_ROW_PROC;
Hibernate mapping:
<hibernate-mapping>
<class name="com.citi.gcgna.cdf.slc.presentation.jfp.borrower.subapps.messages.dao.MessageSP">
<id name="messageId" type="long" />
<property name="subject" type="java.lang.String" />
<property name="message" type="java.lang.String" />
</class>
<sql-query name="insert_SP" callable="true">
<return alias="mess" class="com.citi.gcgna.cdf.slc.presentation.jfp.borrower.subapps.messages.dao.MessageSP">
</return>
{ call INSERT_ROW_PROC() }
</sql-query>
</hibernate-mapping>
Calling Code:
Query q = session.getNamedQuery("insert_SP");
q.list();
I am getting ERROR org.hibernate.util.JDBCExceptionReporter - Invalid column index and could not execute query message.
Could you please help me to solve this issue?
Thanks,
Durgha Prasad