I am getting same error even if edit the script .
[2018-08-14 18:44:45,050] INFO (js-connector:?): call to db failed: JavaException: java.sql.SQLSyntaxErrorException: ORA-00900: invalid SQL statement
and I tried different way . it returns false no error
--------------------------------------------------------
importPackage(Packages.ca.uhn.hl7v2.model.primitiv e);
importPackage(Packages.oracle.jdbc.driver);
importPackage(java.sql);
java.sql.DriverManager.registerDriver (new OracleDriver());
// Change connection info here !!!
// jdbcracle:thin:@<host>/<service_name>
// jdbcracle:thin:@<host>:<sid>
var dbConn = DatabaseConnectionFactory.createDatabaseConnection ('oracle.jdbc.driver.OracleDriver','jdbc
racle:th in:@192.168.0.226:1521:XXX','CCCCC','XXX');
conn = dbConn.getConnection();
//var spstmt = dbConn.prepareCall("{ call store_adt_event(?, ?, ?, ?, ?, ?, ?, ?) }");
var spstmt = conn.prepareCall("{ call MIRTH_TEST_PROCEDURE(?) }");
spstmt.registerOutParameter(1, OracleTypes.CURSOR);
logger.debug(spstmt.execute()); /// it returns false.
//var result=spstmt.executeQuery();
//var result = spstmt.getResultSet();//getInt("pr_key");
//logger.debug("size=="+result.size());
//logger.info("new key=" + newnewKey);
dbConn.close();
----------------------------------------------------------