I am new to Moodle development. I am trying to develop a local addon with which I intend to create a table that triggers a local procedure. So basically my plugin will be using PL/SQL. The problem now is that as I am getting to learn how to use XMLDB by the editor as well as by understanding the install.xml file, I realized that through the editor it's not possible to create a local procedure neither to create a trigger for a table. I also looked at the xmldb.xsd file, and I couldn't see how we can add a local procedure manually to the install.xml file.
I hope that my issue was understood, and I hope someone can give me a help on that.