Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are the steps to prepare a Database adapter that implements procedures?

April 26, 2017adapter database implements prepare procedures steps

0

10 Posted

What are the steps to prepare a Database adapter that implements procedures?

1 Answer

0

10 Posted

The steps are very similar to subscribing to events. However, the procedure that the Database adapter will call is imp___. This procedure will have OUT arguments corresponding to the OUT arguments in the procedure defined in iStudio. In addition to writing PL/SQL code to perform the necessary tasks, the OUT arguments must be filled in with correct values. Write this code in iStudio when creating the message, or modify the stored procedure SQL script before loading it into the database. If the start script is used to start the Database adapter, there is a way to determine if the Database adapter was started properly. This can be viewed in the oailog.txt file in the logs directory of the Database adapter.