Oracle8i Application Developer's Guide - XML Release 3 (8.1.7) Part Number A86030-01 |
|
B2B XML Application: Step by Step , 14 of 32
Run reset.sql
to clean up your environment and rerun this application.
This calls the following 16 PL/SQL scripts:
reset.sql
script first stops all four queue applications by calling the stopQueueApp1 through 4, then drops them by calling dropQueueApp1 through 4, and restarts them by calling startQueueApp1 through 4.
The script also prompts you to Hit Return to Exit.
connect aqMessBrok/aqMessBrok start stopQueueApp1 start stopQueueApp2 start stopQueueApp3 start stopQueueApp4 start dropQueueApp1 start dropQueueApp2 start dropQueueApp3 start dropQueueApp4 start createQueueApp1 start createQueueApp2 start createQueueApp3 start createQueueApp4 start startQueueApp1 start startQueueApp2 start startQueueApp3 start startQueueApp4 prompt Press [Return] to exit ! pause exit
These four scripts are called from reset.sql.
They use PL/SQL procedure dbms_aqadm.stop_queue
to stop the queues.
execute dbms_aqadm.stop_queue(queue_name=>'AppOneMsgQueue');
execute dbms_aqadm.stop_queue(queue_name=>'AppTwoMsgQueue');
execute dbms_aqadm.stop_queue(queue_name=>'AppThreeMsgQueue');
execute dbms_aqadm.stop_queue(queue_name=>'AppFourMsgQueue');
These four scripts are called from reset.sql
. They use PL/SQL procedure dbms_aqadm.drop_queue
to drop the queues.
execute dbms_aqadm.drop_queue (queue_name=>'AppOneMsgQueue');
execute dbms_aqadm.drop_queue (queue_name=>'AppTwoMsgQueue');
execute dbms_aqadm.drop_queue (queue_name=>'AppThreeMsgQueue');
execute dbms_aqadm.drop_queue (queue_name=>'AppFourMsgQueue');
These four scripts are called from reset.sql
. They use PL/SQL procedure, dbms_aqadm.create_queue
to create the queues.
execute dbms_aqadm.create_queue (queue_name=>'AppOneMsgQueue', queue_ table=>'AppOne_QTab');
execute dbms_aqadm.create_queue (queue_name=>'AppTwoMsgQueue', queue_ table=>'AppTwo_QTab');
execute dbms_aqadm.create_queue (queue_name=>'AppThreeMsgQueue', queue_ table=>'AppThree_QTab');
execute dbms_aqadm.create_queue (queue_name=>'AppFourMsgQueue', queue_ table=>'AppFour_QTab');
These four scripts are called from reset.sql
. They use PL/SQL procedure, dbms_aqadm.start_queue
to start the queues.
execute dbms_aqadm.start_queue(queue_name=>'AppOneMsgQueue');
execute dbms_aqadm.start_queue (queue_name=>'AppTwoMsgQueue');
execute dbms_aqadm.start_queue (queue_name=>'AppThreeMsgQueue');
execute dbms_aqadm.start_queue (queue_name=>'AppFourMsgQueue');
This SQL script deletes orders from the Retailer-Supplier database Customers table according to the customer's ID.
set ver off accept CustName prompt 'Drop all for customer named > ' Delete LINE_ITEM I Where I.ORD_ID in (Select O.ID From ORD O Where O.CUSTOMER_ID in (Select C.ID From CUSTOMER C Where Upper(C.NAME) = Upper('&CustName'))) / Delete ORD O Where O.CUSTOMER_ID in (Select C.ID From CUSTOMER C Where Upper(C.NAME) = Upper('&CustName')) /
|
Copyright © 1996-2000, Oracle Corporation. All Rights Reserved. |
|