code: public static String getStoredProcedureFullName(String decodedSql) {
          String spName = null;
  
          Pattern regexPattern = null;
          Matcher regexMatcher = null;
  
          regexPattern = Pattern.compile(REGEX_PROCEDURE_FULL_NAME, Pattern.CASE_INSENSITIVE);
          regexMatcher = regexPattern.matcher(decodedSql);
  
          if (regexMatcher.find() == true) {
              spName = regexMatcher.group();
  
              spName = spName.trim();
          } else {
              throw new IllegalArgumentException(String.format(ERROR_FULL_PROCEDURE_NAME_NOT_FOUND, decodedSql));
          }
  
          return spName;
      }
docs: Returns full function name. Example:
  call schema.package.name - "schema.package.name" would be returned
  
  @param decodedSql SQL String which would be processed
  @return full procedure name