Help About TEST PROCEDURE

Hi all, does somebody have an idea about this qustion?.....

This is my script (for data migation) :

--PH1_LOAD.sql

create or replace view myview2 as
select substr(cl.old_system_id,instr(cl.old_system_id,':')+1,4) as order_id,

		substr(cl.old_system_id,instr(cl.old_system_id,':')+6) as item_id,
		c.customer_id as customer_id,
		p.product_id as product_id,
		ROUND(price.list_price-(price.list_price*price.discount_available)/
100,2) as actual_price,
		cl.quantity as quantity,
		ROUND(price.list_price-(price.list_price*price.discount_available)/
100*cl.quantity,2) as total,
		cl.order_date as order_date,
		cl.ship_date as ship_date,
		cl.old_system_id as old_sys_ref
from 		PH1_CA_LOAD cl,
		PH1_SITE_MAP_LOAD sml,
		PH1_CA_PROD_CONV_LOAD prod,
		PH1_CA_PRICE_DATA_LOAD price,
		customer c,
		product p
where 	substr(cl.old_system_id,1,instr(cl.old_system_id,':')-1) =
sml.site_code
		and c.name = sml.billing_customer
		and prod.description = p.description
		and cl.old_description = prod.old_code
		and prod.old_code = price.ca_product_code

prompt Insert all items in PH1_ITEM
insert all into
PH1_ITEM(order_id,item_id,customer_id,product_id,actual_price,quantity,total,order_date,ship_date,old_sys_ref) values(order_id,item_id,customer_id,product_id,actual_price,quantity,total,order_date,ship_date,old_sys_ref) select * from myview1
/

insert all into
PH1_ITEM(order_id,item_id,customer_id,product_id,actual_price,quantity,total,order_date,ship_date,old_sys_ref) values(order_id,item_id,customer_id,product_id,actual_price,quantity,total,order_date,ship_date,old_sys_ref) select * from myview2
/

*My question id : what example of TEST PROCEDURE can I make BEFORE AND AFTER PH1_LOAD script?
and I should update results in TEST TABLE SUITE like this:

(test_id			NUMBER(8),
phase_number		NUMBER(2),
task_number			NUMBER(2,1),
solution_number		NUMBER(1),
test_name			VARCHAR2(50),
test_desc			VARCHAR2(200),
before_total		NUMBER(8),
after_total			NUMBER(8),
result			VARCHAR2(4) )

Thanks a lot.... Received on Mon Aug 27 2007 - 04:38:52 CDT