Published on InterSystems Developer Community (https://community.intersystems.com)

Home > How to Execute a Stored Procedure in a remote SQL Server Database ?

Question
Daniel Castro · Jun 15, 2022

How to Execute a Stored Procedure in a remote SQL Server Database ?

Hi,

I want to access a Stored Procedure in a remote SQL Server Database. I am quite new to Object script.

The stored procedure has 3 parameters: 2 datetime parameters and 1 integer.

Which is the best way to do that? I'm wondering if I can use the link stored procedure feature inside object script or some SQL statement in Object Script.

This SP returns a set of rows which I want to read, transform and save in a persistent class.

Thanks in advance,

#InterSystems IRIS
Product version: IRIS 2022.1
$ZV: IRIS for Windows (x86-64) 2021.1 (Build 215.3U)

Source URL:https://community.intersystems.com/post/how-execute-stored-procedure-remote-sql-server-database