When using the Database Connector module, there is a java action called 'Execute Statement' As I understand it, you can simply add a sql statement into that java action. If you have a stored procedure, are you able to execute using a statement like the following?
Depending on what external database you use, this connector may also be of use: https://appstore.home.mendix.com/link/app/8683/Mendix/Oracle-Connector-(Beta). Github: https://github.com/ako/OracleConnector
Readme contains some examples of calling oracle stored procedures (plsql): https://github.com/ako/OracleConnector/blob/master/readme.md
Laxman, keep in mind that as far as I know, the db replication module does not use a connection pool. So if you plan on using this for anything other than a nightly synchronization job it's probably a good idea to implement one.