This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

DEVELOPERS FORUM - How to Call Store Procedure from ServerSide Method

Offline Archive User over 10 years ago

Shalabh Jain - Tuesday, November 5, 2013 3:21 AM:

Dear All,

I have defined one Stored Procedure in SQLs section named as Sp_CreateUser.

I just want to access the Stored Procedure from ServerSide Method.

Can anybody tell me how to do that, quick response will be highly appreciated.

Request you to provide some small example.

Thanks and Regards,
Shalabh Jain

Amit Nawale - Thursday, November 21, 2013 2:11 AM:

Hi Shalabh

You can try following code for reference:-

Item callframe = this.newItem("SQL", "SQL PROCESS");

callframe.setproperty("name", "activity_status_rollup");

callframe.setproperty("PROCESS", "CALL");

callframe.setproperty("ARG1", projectId);

callframe.setproperty("ARG2", tzName);

Item resultframe = callframe.apply();

Thanks,

Amit.

rrt - Wednesday, February 10, 2016 12:05 AM:

hi Amit what is projectId and tzname in your code