Create a new message type.
Syntax CREATE MESSAGE TYPE message_type [AUTHORIZATION owner] [VALIDATION = {NONE | EMPTY | WELL_FORMED_XML | VALID_XML WITH SCHEMA COLLECTION collection }] [;] Key: owner - A database user or role to own the message type. NONE - The message body may contain any data. EMPTY - The message body must be NULL WELL_FORMED_XML - The message body must contain well-formed XML. WITH SCHEMA COLLECTION - XML that conforms to a schema in the collection specified.
Both sides of a conversation must define the same name for a message type.
Example
CREATE MESSAGE TYPE
[//SS64.com/Sample/SubmitSample]
VALIDATION = WELL_FORMED_XML ;
"Don't kill the messenger" - Sophocles 442 B.C.
Related commands:
ALTER MESSAGE TYPE
DROP MESSAGE TYPE
Equivalent Oracle commands: DBMS_AQ, DBMS_AQELM,UTL_HTTP