Skip to main content
vmanojrc30
Contributor
Aug 16, 2023 10:08 PM UTC
Solved

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 DM Jobs for data imports to cube.

Appreciate any pointers how I can implement this.

 

 

StevenAnswer
Contributor
Aug 17, 2023 1:26 PM UTC

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

View in thread

5 replies

StevenAnswer
Contributor
Aug 17, 2023 1:26 PM UTC

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

    vmanojrc30Author
    Contributor
    Aug 17, 2023 4:18 PM UTC

    Thanks Steve! Is the [StoredProc] is a string that contains the Stored Procedure (line of codes) and need to be within the BR?

    Steven
    Contributor
    Aug 17, 2023 4:23 PM UTC

    [StoredProc] is the name of the stored procedure you are running.

    I have a stored procedure named TruncateMyTable

    I would be: Exec TruncateMyTable

     

      vmanojrc30Author
      Contributor
      Aug 17, 2023 5:32 PM UTC

      Thanks I will try that

      vmanojrc30Author
      Contributor
      Aug 22, 2023 2:00 AM UTC

      I am able to execute the stored procedure. Now as a next step I need to execute a Data Management job to import the data from DB to OS Cube.

      Prior to that I need to check whether the stored procedure executed successfully without errors. How can I check for errors within the BR? The brapi.Database.ExecuteActionQuery command has a Boolean parameter to log errors. But I am not sure how I can access those error messages.

      Terms & ConditionsAccessibility statement