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.

Does Oterro store stored procedures and triggers within its schema? How are these written and installed?

April 26, 2017installed oterro procedures schema store stored triggers written

0

Posted

Does Oterro store stored procedures and triggers within its schema? How are these written and installed?

1 Answer

0

Posted

Oterro stores triggers and stored procedures in the database itself. The stored procedures originate in ASCII files and are inserted using the PUT command. Once a Stored Procedure has been added to the Database, it can be made to function as a Trigger by using the ALTER TABLE command, where you can identify Stored Procedure to be associated with the table to be launched at an UPDATE, INSERT or DELETE.