Joined: Mon Oct 22, 2007 2:59 am Posts: 1
|
hi, i got a problem when i was reading store procedre return data .... it is returing string data... i am using sql 2000 as data base and hibernate 3
*********my store procedure**********
CREATE PROCEDURE getmaxRatiosnapshot
@returnValue varchar(20) out
AS
BEGIN
select @returnValue=max(BSRSSId) from BSRatioSnapShot
if( @returnValue=null )
set @returnValue='2000000'
END
GO
*************xml*************
<sql-query name="selectAllEmployees_SP" callable="true">
........ what should i type here ...........
{ call getmaxRatiosnapshot(?) }
</sql-query>
**************class*************
SQLQuery query= (SQLQuery)session.getNamedQuery("selectAllEmployees_SP");
what changes i want to make to read that string value
please help me
|
|