DMONIX

index

Package DM_PROC
Constants
EXPORT_SUCCESSFUL Export of table data was successful
EXPORT_FAILED Export of table data failed
IMPORT_SUCCESSFUL Import of table data was successful
IMPORT_FAILED Import of table data failed

Types

Program units
BACKUPCUSTOMERDATA Exports customer data to a binary file
COALESCEINDEXES Coalesce all indexes
CREATECUSTOMER Updates data in the reptest table
MAKEORDER Makes an order of an product for a customer
RECOVERCUSTOMERDATA Imports spatial data from a file.
REPORTMISSEDDELIVERIES Finds all orders that have missed their delivery date
WRITELOGENTRIES Writes data from a logentry to the alert.log file
WRITETOALERTLOG Writes data to the alert.log file

EXPORT_SUCCESSFUL

EXPORT_SUCCESSFUL CONSTANT NUMBER := 1

Export of table data was successful

EXPORT_FAILED

EXPORT_FAILED CONSTANT NUMBER := -2

Export of table data failed

IMPORT_SUCCESSFUL

IMPORT_SUCCESSFUL CONSTANT NUMBER := 1

Import of table data was successful

IMPORT_FAILED

IMPORT_FAILED CONSTANT NUMBER := -1

Import of table data failed

BACKUPCUSTOMERDATA

function BackupCustomerData(p_fileName varchar2 DEFAULT to_char(sysdate, 'YYYYMMDDHH24MISS')||'.dmp', 
                            p_logging boolean DEFAULT false)
                            return number

Exports customer data to a binary file

Parameters
p_fileName The name of the dump file
p_logging If the procedure should log progress to alert.log

Returns
The result of the operation

See also
EXPORT_SUCCESSFUL
EXPORT_FAILED

COALESCEINDEXES

procedure CoalesceIndexes(p_logging boolean DEFAULT false)

Coalesce all indexes

Parameters
p_logging Logging on/off

CREATECUSTOMER

procedure CreateCustomer(p_NAME customer.name%type,
                         p_ADDRESS customer.address%type,
                         p_COUNTRY customer.country%type,
                         p_EXPIREDATE customer.expiredate%type)

Updates data in the reptest table

Parameters
p_NAME The customer name
p_ADDRESS The address
p_COUNTRY The country
p_EXPIREDATE The date when the customer expires

MAKEORDER

procedure MakeOrder(p_CUSTOMER_ID orders.customer_id%type,
                    p_PRODUCT_ID orders.product_id%type,
                    p_DELIVER_DATE orders.delivery_date%type)

Makes an order of an product for a customer

Parameters
p_CUSTOMER_ID The customer id
p_PRODUCT_ID The product id
p_DELIVER_DATE The delivery date

RECOVERCUSTOMERDATA

function RecoverCustomerData(p_fileName varchar2, 
                             p_logging boolean DEFAULT false)
                             return number

Imports spatial data from a file.

Parameters
p_fileName The name of the dump file
p_logging If the procedure should log progress to alert.log

Returns
The result of the operation

See also
IMPORT_SUCCESSFUL
IMPORT_FAILED

REPORTMISSEDDELIVERIES

procedure ReportMissedDeliveries

Finds all orders that have missed their delivery date

WRITELOGENTRIES

procedure WriteLogEntries(p_logEntry ku$_LogEntry)

Writes data from a logentry to the alert.log file

WRITETOALERTLOG

procedure WriteToAlertLog(p_logString varchar2,
                          p_logging boolean DEFAULT true)

Writes data to the alert.log file

Parameters
p_logString The string to write
p_logging Logging on/off