Call stored procedure frome external database

0
Hi , Im got connected with external database using Database Replication module for mapping the built in database with external DB. I also used Database connector module and display external data using simple query. But im unable call Stored procedure using Database Connector module. Can someone suggest how to call a stored procedure in medix using DB connector or DB Replication.
asked
3 answers
0

Hi  Laxman,

   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?

 EXEC storedprocname

 Best,

Rob

answered
0

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

 

answered
0

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.

answered