CREATE MESSAGE TYPE

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.

Examples

 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


 
Copyright © 1999-2024 SS64.com
Some rights reserved