Hi,

I'm having a problem calling a SQL Server stored procedure that returns value directly:

CREATE PROCEDURE TestProc
AS
BEIGN
RETURN 1
END

Doeas anyone jnow how to implement it as a named query in nhibernate??

something like:
<sql-query name="Test" callable="true">
<return-scalar column="Value" type="Int32" />
{ call TestProc}
</sql-query>

????????

it return error when i try to get a value from it:
Int32 ID = hqlSupport.Session
.GetNamedQuery("Test")
.List<Int32>()[0];
"Index out of bounds"

Please help...

Solved:

<sql-query name="DefaultDeriveNewID" callable="true">
<return-scalar column="Value" type="Int32" />
<![CDATA[DECLARE @id int
EXECUTE @id = DeriveNewID :identifierID, :incCount
SELECT @id AS Value]]>
</sql-query>