Forum Discussion

vmanojrc30's avatar
vmanojrc30
Contributor
2 years ago

Calling DB Stored Procedures from OS

I want to execute a list of DB Stored procedures after executing a DM step in OS. Is it possible to call a DB Stored Procedure from OS?After the Stored Procedures are run, I want to execute a list of...
  • Steven's avatar
    2 years ago

    Yes, you can call a stored procedure from OS:

    Do something like this in a business rule:

     

    Using dbConnApp = BRApi.Database.CreateApplicationDbConnInfo(si)
    BRApi.Database.ExecuteActionQuery(dbConnApp, "EXEC [StoredProc]", True, True)
    End Using