private StoredProcedure newStoredProc(String name, String source) {
    StoredProcedure storedProcedure = new StoredProcedure();
    storedProcedure.setCatName(hplSqlSession.currentCatalog());
    storedProcedure.setName(name);
    storedProcedure.setOwnerName(hplSqlSession.currentUser());
    storedProcedure.setDbName(hplSqlSession.currentDatabase());
    storedProcedure.setSource(source);
    return storedProcedure;
  }
Execute a stored procedure using CALL or EXEC statement passing parameters
hplsql/src/main/java/org/apache/hive/hplsql/functions/HmsFunctionRegistry.java