Thanks Rai.

I have created a stored procedure with Void as a return type, so there is no OUT Parameters in Activity.I have only one input Parameter which accepts the Case ID and based on that it deletes the row.

Below is my Stored Procedure I have used to call from activity

CREATE OR REPLACE FUNCTION somefunction(CaseID Text) RETURNS Void AS

$$                                   

BEGIN

Delete from pc_data_XXXX  where Column Name = CaseID;

Delete from pc_data_YYYY where Column Name = CaseID;

Delete from pc_data_ZZZZ  where Column Name = CaseID;

Delete from pc_data_FFFF where Column Name = CaseID;

Delete from pc_data_RRRR  where Column Name = CaseID;

Delete from pc_data_DDDD where Column Name = CaseID;

exception when others then

begin

end;

COMMIT;

END; $$

LANGUAGE 'plpgsql' VOLATILE

SECURITY DEFINER

 

 Below is the syntax I have implemented in Connect-SQL to delete the record

      \{{resultset} = call somefunction ({SomePage.CaseID})\}

My guess is 'resultset' is expecting some value returned by function even though it is void. It will be great if you or someone can help me to how to call the Stored Procedure in connect sql without return type .

Note: I have tried by removing the resultset in the connect SQL and received the syntax error .

B/R

Siva