Calling Stored-Procedures from Servoy method

Classic Servoy
1

Hi all,

Can some please help me to call the following Stored-Procedures from Servoy method?

CREATE PROCEDURE person_in_household
@m_subj_num integer
AS
select dbo.ID.subj_num AS ID_SUBJ_NUM, dbo.ID.ID_LAST_NAME, dbo.ID.ID_FIRST_NAME, dbo.ID.ID_GENDER
, dbo.persons_in_household.subj_num as HOUSEHOLD_SUBJ_NUM, dbo.persons_in_household.household_id from dbo.persons_in_household, dbo.ID
where dbo.persons_in_household.subj_num = dbo.ID.subj_num
AND dbo.persons_in_household.household_id = (select household_id from dbo.persons_in_household where subj_num = @m_subj_num)

Thanks in advance,

Abrahim

2

check databaseManager.executeStoredProcedure(…)