Gateway Event Scripts - Stored Procedure

Hi there,

Is it possible to execute stored procedures in a gateway event script on tag change?

Thanks,
Liam

Hi,
I would definitely say that it is possible.
You can either call the stored procedure with the system.db.createSProcCall() and then the system.db.execSProcCall() or you can have the stored procedure call in a named query and then call the named query with system.db.runNamedQuery().

I haven’t tried it myself though, but can see the functions are available in he Gateway Tag Change Scripts.

Mathias

1 Like