To call a stored procedure you have to use some native objects specific to the language you are using (.NET or Java) that you can get by calling the RuntimePublic.Db API methods. In order to obtain them, all query objects have a method that return the language native object:
When using language internal objects (.NET or Java), make sure that you comply with:
In this example, we have a external database accessed through a connection called 'Data Warehouse' that is defined in the environment management console.
We will call a store procedure called COMPUTE_SCORE, which calculates the score performance for an employee. To do it, it receives the employee's name and the output parameter, an integer number, and returns that parameter with the value correspondent to the performance for the employee.
Overview of RuntimePublic.Db API | About APIs