-- hier erfolgt die Definition der einzelnen Nachrichten

CREATE TABLE ALERT_MSG_TYPE
(
  ID           NUMBER                           NOT NULL,
  MSG_NAME     VARCHAR2(100),
  MSG_SUBJECT  VARCHAR2(100),
  MSG_TEXT     VARCHAR2(2000)
)
USERSLOGGING 
COMPRESS 
NOCACHE
NOPARALLEL
MONITORING;

-- hier erfolgt die Definition der einzelnen Empfänger der Nachrichten

CREATE TABLE ALERT_MSG_RECEIVER
(
  ID             NUMBER                         NOT NULL,
  ALERT_TYPE     VARCHAR2(50)                   DEFAULT 'MAIL'                NOT NULL,
  ALERT_ADDRESS  VARCHAR2(200)                  NOT NULL
)
TABLESPACE USERS
LOGGING 
COMPRESS 
NOCACHE
NOPARALLEL
MONITORING;



CREATE OR REPLACE PACKAGE PKG_SEND_MAILS AS
 ----------------------------------------------------------------------------------
 --	 SEND MAILS ALL ADRESS WHIT my_id=id
 ----------------------------------------------------------------------------------
 PROCEDURE SEND_ALERT_MSG (my_id IN NUMBER);
 PROCEDURE SEND_ALERT_MSG (my_id IN NUMBER, my_text in varchar2);
------------------------------------------------------------------------------------
--end package
------------------------------------------------------------------------------------
end;



-- ein Beispielaufruf; 

exec PKG_SEND_MAILS.send_alert_msg(4);