Hello All,
I have a stored Procedure which doesn't return result set from any specific tables. Below is the SP :
PROCEDURE [dbo].[spCMTGetClientSummaryRegion]
AS
BEGIN
SELECT 'North East' AS 'Region', '1' AS 'ActiveClients', '3.03%' AS 'Percentage', '1' AS 'Prospects', '3.03%' AS 'TotalPercentage'
END
Output :
Region ActiveClients Percentage Prospects TotalPercentage
North East 1 3.03% 1 3.03%
Now, I want to call this SP from Hibernate and store the result in a
java bean object. Below is the hibernate call:
<sql-query name="callCMTGetClientSummaryRegion" callable="true">
<return alias="Client" class="ClientSummaryRegionVO"/>
{call spCMTGetClientSummaryRegion() }
</sql-query>
Where my bean object is ClientSummaryRegionVO. Please help.
Thanks in advance.
Regards,
Niranjan