Hi,
I am trying to called a Postgres stored procedure from Hibernate. The problem is that when the stored procedure is called, it doesn't return a ResultSet object. I actually get back a PGobject.
I'm not sure what my stored procedure should actually be returning. At the moment I have
Code:
CREATE OR REPLACE FUNCTION isValid(accountNo integer)
RETURNS integer AS
My mapping file says
Code:
<sql-query name="isValid" callable="true">
<return-scalar column="result" type="integer"/>
{? = call isValid(:accountNo)}
</sql-query>
I'm guessing that to get a result set back I should be have the return type of my stored procedure as an integer, but what should it be?
Thanks
Graham
Login
FAQ
Search