Task 1: Creating the Message Type

Create a user-defined type to define the information that you want to track for the applications. This example creates the strmadmin.app_info type for messages that will contain a parameter and a value.

To create the strmadmin.app_info type: 

1. Prepare your environment for messaging if you have not already done so. See "Preparing for Messaging".

2. In Oracle Enterprise Manager, log in to the database as the Oracle Streams administrator.

3. Go to the Database Home page.

4. Click Schema to open the Schema subpage.

5. Click Object Types in the User Defined Types section.

6. On the Object Types page, click Create to open the Create Object Type page.

7. Enter app_info in the Name field.

8. Ensure that strmadmin is selected in the Schema field.

9. Ensure that Predefined Type is selected for Datatype in the Attributes section.

10. Click Add in the Attributes section to open the Add Predefined Type Attributes page.

11. To add the first attribute to the app_info type:

    1. Enter parameter in the Name field.

    2. Select VARCHAR2 for Type.

    3. Enter 20 in the Length field.

    4. Click OK.

12. On the Create Object Type page, ensure that Predefined Type is selected for Datatype in the Attributes section.

13. Click Add in the Attributes section to open the Add Predefined Type Attributes page.

14. To add the next attribute to the app_info type:

    1. Enter value in the Name field.

    2. Select NUMBER for Type.

    3. Enter 12 in the Length field.

    4. Click OK.

15. On the Create Object Type page, click OK to create the type.

16. Complete the steps in "Task 2: Configuring a Queue and a Messaging Client" to continue this extended example.