   DYNAMIC RESULT SETS 0
   MODIFIES SQL DATA
   DETERMINISTIC -- Returns the same ID for the same logger name.
-  AUTONOMOUS
   NO EXTERNAL ACTION
   PARAMETER CCSID UNICODE
  P_GET_LOGGER: BEGIN

    SELECT LOGGER_ID INTO PARENT FROM FINAL TABLE (
      INSERT INTO CONF_LOGGERS_EFFECTIVE (NAME, PARENT_ID, LEVEL_ID)
      VALUES (STRING, PARENT, PARENT_LEVEL));
    COMMIT;
   ELSE
    -- It is already register in the effective table, thus take the id of that
    -- logger as parent.

  DYNAMIC RESULT SETS 0
  MODIFIES SQL DATA
  NOT DETERMINISTIC -- The same name could refers to a different logger.
  NO EXTERNAL ACTION
  PARAMETER CCSID UNICODE
 P_ANALYZE: BEGIN
