My task is - get data page from database with total amount of records using stored procs in ONE QUERY. It can be one stored proc or 2 in the batch.

It's appears that there is no way to work with output or result params of stored procs.

I tried IMultiQuery but it doesn't work with ISQLQuery.

Any ideas?
Thanks in advance.

[b]Hibernate version:[/b]
2.0.1
[b]Mapping documents:[/b]

[b]Code between sessionFactory.openSession() and session.close():[/b]

[b]Full stack trace of any exception that occurs:[/b]

[b]Name and version of the database you are using:[/b]
MSSQL 2005
[b]The generated SQL (show_sql=true):[/b]

[b]Debug level Hibernate log excerpt:[/b]


Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html