Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\rtasst\wb_rt_profile_service.pls
CREATE OR REPLACE PACKAGE wb_rt_profile_service AUTHID CURRENT_USER AS COLUMNTYPE NUMBER:= 0; TABLETYPE NUMBER:= 1; PROFILETYPE NUMBER:= 2; BUSRULETYPE NUMBER:= 3; REGULARCOL NUMBER:= 0; RANKCOL NUMBER:= 1; DRANKCOL NUMBER:= 2; PATTERNCOL NUMBER:= 3; DATATYPECOL NUMBER:= 4; COMMONFORMAT NUMBER:= 5; LENGTHCOL NUMBER:= 6; PRECISIONCOL NUMBER:= 7; SCALECOL NUMBER:= 8; NULLVALUE NUMBER:= 2; type floatType is table of FLOAT index by BINARY_INTEGER; type numberType is table of NUMBER index by BINARY_INTEGER; type rowidType is table of VARCHAR2(2000) index by BINARY_INTEGER; type varcharType is table of VARCHAR2(4000) index by BINARY_INTEGER; PROCEDURE setupFKStructures(prfID IN NUMBER); PROCEDURE doLoadingOperations(prfUOID IN VARCHAR2,prfID IN NUMBER, tabID IN NUMBER,auditID IN NUMBER); PROCEDURE analyzeDomains(prfID IN NUMBER,tabID IN NUMBER,auditID IN NUMBER); PROCEDURE analyzePatterns(prfID IN NUMBER,tabID IN NUMBER,auditID IN NUMBER); FUNCTION getPropertyValue(propName IN VARCHAR2,objectID IN NUMBER, objectType IN NUMBER) RETURN VARCHAR2; FUNCTION getNumberPropertyValue(propName IN VARCHAR2,objectID IN NUMBER, objectType IN NUMBER) RETURN NUMBER; PROCEDURE deriveFunctionalDependencies(prfID IN NUMBER,tabID IN NUMBER); PROCEDURE analyzeColumns(prfUOID IN VARCHAR2,prfID IN NUMBER,tabID IN NUMBER, auditID IN NUMBER); FUNCTION createSample(tblID IN NUMBER,sampleSize IN NUMBER,type IN NUMBER) RETURN VARCHAR2; PROCEDURE createFKPartitions(prfID IN NUMBER); PROCEDURE analyzeStructure(prfID IN NUMBER,tabID IN NUMBER,auditID IN NUMBER); PROCEDURE analyzeProfileStructure(prfID IN NUMBER,fkreprofile IN NUMBER); PROCEDURE createFKResults(datatypeStr IN VARCHAR2,prfID IN NUMBER); PROCEDURE debugMsg(prfID IN NUMBER,msg IN CLOB); PROCEDURE deriveRedundantColumns(prfID IN NUMBER); PROCEDURE createPartitionedTables(prfID IN NUMBER); PROCEDURE processFoundFDs(prfID IN NUMBER,tblID IN NUMBER); PROCEDURE analyzeBusinessRules(prfUOID IN VARCHAR2,tabID IN NUMBER, auditID IN NUMBER); PROCEDURE deriveCompositeForeignKeys(prfID IN NUMBER,tblID IN NUMBER); FUNCTION executeStmt(stmt IN VARCHAR2,expectedRows IN NUMBER) RETURN NUMBER; PROCEDURE derivePerfectForeignKeys(datatypeStr IN VARCHAR2,prfID IN NUMBER); PROCEDURE testUKConstraints(prfUOID IN VARCHAR2,tblId IN NUMBER,error IN NUMBER); PROCEDURE testFKConstraints(prfUOID IN VARCHAR2,tblId IN NUMBER,error IN NUMBER); FUNCTION isDebug(prfID IN NUMBER) RETURN BOOLEAN; END wb_rt_profile_service; /
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de