Rem
Rem $Header: template.sql 06-feb-96.13:23:14 kosinski Exp $
Rem
Rem aqjmsdmo.sql
Rem
Rem  Copyright (c) Oracle Corporation 2000. All Rights Reserved.
Rem
Rem    NAME
Rem      aqjmsdmo.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    rbhyrava    07/10/00 - AQ JMS demo -setup
Rem    rbhyrava    07/10/00 - Created
Rem
REM =====================================================
REM SETUP for AQ JMS Demos:create user and payload types 
REM =====================================================
SET echo on;
CONNECT system/manager;
DROP USER jmsuser CASCADE ;
GRANT CONNECT, RESOURCE,AQ_ADMINISTRATOR_ROLE TO jmsuser IDENTIFIED BY jmsuser ;
CONNECT jmsuser/jmsuser;

CREATE TYPE message AS OBJECT (
    id NUMBER,
    city VARCHAR2(30),
    priority NUMBER
);
/

CREATE OR REPLACE TYPE cars AS OBJECT (
    carno NUMBER,
    make  VARCHAR2(20) ,
    year  NUMBER,
    price NUMBER(10,2) ,
    color VARCHAR2(10)
);
/
CREATE OR REPLACE TYPE emp AS OBJECT (
    id    NUMBER ,
    name  VARCHAR2(20),
    carown  cars,
    rank  NUMBER,
    zip   VARCHAR2(5)
);
/
EXIT;

REM ==============================================
REM SETUP complete 
REM ==============================================
