OUTLN_PKG , 2 of 2

Summary of Subprograms

Table 58-1 OUTLN_PKG Package Subprograms

Subprogram	Description
DROP_UNUSED Procedure	Drops all outlines that have not been used since they were created.
DROP_BY_CAT Procedure	Drops all outlines that belong to a particular category.
UPDATE_BY_CAT Procedure	Changes the category of all outlines in one category to a new category.

DROP_UNUSED Procedure

This procedure drops outlines that have never been applied in the compilation of a SQL statement.

Syntax

OUTLN_PKG.DROP_UNUSED;

Parameters

None.

Usage Notes

You may want to use DROP_UNUSED for outlines created on behalf of dynamic SQL statements, that were generated by an application for one time use only. For these statements, the outlines are never used and are simply taking up valuable disk space.

DROP_BY_CAT Procedure

This procedure drops outlines that belong to a particular category.

Syntax

OUTLN_PKG.DROP_BY_CAT (
   cat VARCHAR2);

Parameters

Table 58-2 DROP_BY_CAT Procedure Parameters

Parameter	Description
cat	Category of outlines to drop.

Usage Notes

You may occasionally want to purge a category of outlines. This procedure accomplishes that in a single call.

Example

This example drops all outlines in the DEFAULT category:

OUTLN_PKG.DROP_BY_CAT('DEFAULT');

UPDATE_BY_CAT Procedure

This procedure changes the category of all outlines in one category to a new category. If the SQL text in an outline already has an outline in the target category, then it is not merged into the new category.

Syntax

OUTLN_PKG.UPDATE_BY_CAT ( 
   oldcat VARCHAR2 DEFAULT 'DEFAULT', 
   newcat VARCHAR2 DEFAULT 'DEFAULT');

Parameters

Table 58-3 UPDATE_BY_CAT Procedure Parameters

Parameter	Description
oldcat	Current category to be changed.
newcat	Target category to change outline to.

Usage Notes

Once satisfied with a set of outlines, you might chose to move outlines from an experimental category to a production category. Likewise, you might want to merge a set of outlines from one category into another pre-existing category.

Example

This example changes all outlines in the DEFAULT category to the CAT1 category:

OUTLN_PKG.UPDATE_BY_CAT('DEFAULT', 'CAT1');