Call SQL Package/Store Procedure on ADF Model

navigate to application module and generate AM module class:

Go to class AppModuleImpl and write function (Example):

    public Object callStoredFunction(String stmt, int sqlReturnType) {
       
        DBTransactionImpl dbti = (DBTransactionImpl) this.getTransaction();
        CallableStatement statement =
            dbti.createCallableStatement("BEGIN  ? := "+stmt+";END;", 0);
        try {
            statement.registerOutParameter(1, Types.VARCHAR);
            //Output
            statement.registerOutParameter(2, Types.VARCHAR);
            statement.registerOutParameter(3, sqlReturnType);
            // 5. Set the value of user-supplied bind vars in the stmt
            statement.executeUpdate();
            return statement.getObject(3);
        } catch (SQLException sqlerr) {
            throw new JboException(sqlerr);
        } finally {
            try {
                if (statement != null) {
                    statement.close();
                    Configuration.releaseRootApplicationModule(this, true);
                }
            } catch (SQLException closeerr) {
                throw new JboException(closeerr);
            }
        }

    }