Part 3: Database Build file

So now that we have called the database build file, let’s take a quick look at what it is doing.

–START DATABASE BUILD
drop package ut_p_obj_customer;
drop package ut_p_te_customer;

drop package p_obj_customer;
drop package p_te_customer;

drop type nt_customer_vo;
drop type ot_customer_vo;

drop table customer;

create table customer (
customer_id        number,
account_number     number,
date_created       date,
date_closed        date,
last_billed_date   date,
customer_name      varchar2(80),
address_1          varchar2(150),
address_2          varchar2(150),
city               varchar2(80),
post_code          varchar2(50),
country            varchar2(150),
customer_type      varchar2(10)
);

@ot_customer_vo.tps;
@ot_customer_vo.tpb;
@nt_customer_vo.tps;

@p_te_customer.pks;
@p_te_customer.pkb;

@p_obj_customer.pks;
@p_obj_customer.pkb;

@ut_p_te_customer.pks;
@ut_p_te_customer.pkb;

@ut_p_obj_customer.pks;
@ut_p_obj_customer.pkb;

/

–END DATABASE BUILD

Simply the file begins by dropping all objects, table, packages and types.

It then begins rebuilding, populating and testing.

It is at this stage that any problems with dependencies, or invalid packages will arise.