Is it possible to call either Oracle or SQL server package from Boomi?
Yes you can. You can call SQL functions from Boomi to set properties. You can also call store procedures using the database connector. Here are a couple of examples.
Example 1 - Set properties using a SQL statement calling an Oracle PL/SQL package
Example 2 - Upserting records using an Oracle PL/SQL package called by the database connector
Retrieving data ...