Rem
Rem $Header: template.sql 06-feb-96.13:23:14 kosinski Exp $
Rem
Rem aqoradmo.sql
Rem
Rem  Copyright (c) Oracle Corporation 2000. All Rights Reserved.
Rem
Rem    NAME
Rem      aqoradmo.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 API demo - setup
Rem    rbhyrava    07/10/00 - Created
Rem

REM ===========================================================
REM SETUP for AQ Java API demos:create user and payload types 
REM ===========================================================
SET echo on;
CONNECT system/manager;
DROP USER aqjava CASCADE;
GRANT CONNECT, RESOURCE, AQ_ADMINISTRATOR_ROLE TO aqjava IDENTIFIED BY aqjava;
GRANT EXECUTE ON DBMS_AQADM TO aqjava;
GRANT EXECUTE ON DBMS_AQ TO aqjava;
CONNECT aqjava/aqjava;

CREATE TYPE address AS OBJECT (
    street VARCHAR (30), 
    city VARCHAR(30)
);
/
CREATE TYPE person AS OBJECT (
    name VARCHAR (30), 
    home ADDRESS
);
/
EXIT;
REM ==============================================
REM SETUP complete
REM ==============================================
