Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\browserasst\views\owb_uprop.sql
Rem Rem $Header: owb_uprop.sql 15-apr-2008.14:18:40 xxzhang Exp $ Rem Rem owb_uprop.sql Rem Rem Copyright (c) 2006, Oracle. All rights reserved. Rem Rem NAME Rem owb_uprop.sql - OWB_UPROP package declaration Rem Rem DESCRIPTION Rem Table functions providing optimized property meta/data retrieval Rem Rem NOTES Rem See the last section of owb_uprop_views.sql for the queries supporting Rem these functions. Rem Rem MODIFIED (MM/DD/YY) Rem xxzhang 04/15/08 - Rem bjeffrie 02/18/06 - Created Rem -- WARNING! service/impl/assistant/RuntimeInstaller will throw exception if -- these are enabled. --SET ECHO ON --SET FEEDBACK 1 --SET NUMWIDTH 10 --SET LINESIZE 80 --SET TRIMSPOOL ON --SET TAB OFF --SET PAGESIZE 100 CREATE OR REPLACE PACKAGE owb_uprop AS TYPE fqPusageDef_set_t IS TABLE OF SUB_FQ_PUSAGE_DEF%ROWTYPE; TYPE fqPusage_set_t IS TABLE OF ALL_IV_EXT_OBJECT_PROPERTIES%ROWTYPE; -- cdefTypeName is processed with LIKE, not '=' so wilcards are OK. -- send 'true' for includeHidden if you want the hidden properties also FUNCTION getFqPropertyUsageDefinitions(cdefTypeName IN VARCHAR2, includeHidden IN VARCHAR2 DEFAULT 'false') RETURN fqPusageDef_set_t PIPELINED; -- elementId is the id of the element you want property definitions for -- send 'true' for includeHidden if you want the hidden properties also FUNCTION getFqPropertyUsageDefinitions(elementId IN NUMBER, includeHidden IN VARCHAR2 DEFAULT 'false') RETURN fqPusageDef_set_t PIPELINED; -- propertyType is one of 'CONFIG', 'LOGICAL', 'USERDEF' FUNCTION getProperties(objectId IN NUMBER, configurationId IN NUMBER DEFAULT 0, propertyType1 IN VARCHAR2 DEFAULT 'LOGICAL', propertyType2 IN VARCHAR2 DEFAULT 'DUMMY', propertyType3 IN VARCHAR2 DEFAULT 'DUMMY', includeHidden IN VARCHAR2 DEFAULT 'false') RETURN fqPusage_set_t PIPELINED; END owb_uprop; /
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de