Rem
Rem $Header: beacon_schema_upgrade.sql 26-jun-2003.18:40:57 snakai Exp $
Rem
Rem beacon_schema_upgrade.sql
Rem
Rem Copyright (c) 2003, Oracle Corporation.  All rights reserved.  
Rem
Rem    NAME
Rem      beacon_schema_upgrade.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    snakai      06/26/03 - snakai_bug-2878367_main
Rem    snakai      04/24/03 - Created
Rem


ALTER TABLE MGMT_BCN_TXN_HTTP 
  MODIFY ( hidden_input_hint     VARCHAR2(4000) );

DROP TYPE mgmt_bcntxn_step_array;

DROP TYPE mgmt_bcntxn_step;

CREATE OR REPLACE TYPE mgmt_bcntxn_step AS OBJECT
  (
     txn_guid             VARCHAR2(32),
     request_mode         NUMBER,
     url                  VARCHAR2(2000),
     http_method          CHAR(1),
     target_frame         VARCHAR2(256),
     headers              VARCHAR2(4000),
     postdata             VARCHAR2(32767),
     anchor_hint          CHAR(1),
     hidden_input_hint    VARCHAR2(4000),
     auth_realm           VARCHAR2(128),
     auth_user            VARCHAR2(64),
     auth_passwd          VARCHAR2(64),
     ping_hostname        VARCHAR2(128),
     ping_mode            NUMBER,
     ping_num_packets     NUMBER,
     ping_max_ttl         NUMBER,
     ping_timeout         NUMBER        
  );
/

CREATE OR REPLACE TYPE mgmt_bcntxn_step_array AS 
       TABLE OF mgmt_bcntxn_step;
/