67 DBMS_OUTLN_EDIT

The DBMS_OUTLN_EDIT package is an invoker's rights package.

Summary of DBMS_OUTLN_EDIT Subprograms

Table 67-1 DBMS_OUTLN_EDIT Package Subprograms

Subprogram	Description
CHANGE_JOIN_POS Procedure	Changes the join position for the hint identified by outline name and hint number to the position specified by `newpos`
CREATE_EDIT_TABLES Procedure	Creates outline editing tables in calling a user's schema
DROP_EDIT_TABLES Procedure	Drops outline editing tables in calling the user's schema
GENERATE_SIGNATURE Procedure	Generates a signature for the specified SQL text
REFRESH_PRIVATE_OUTLINE Procedure	Refreshes the in-memory copy of the outline, synchronizing its data with the edits made to the outline hints

CHANGE_JOIN_POS Procedure

This function changes the join position for the hint identified by outline name and hint number to the position specified by newpos.

Syntax

DBMS_OUTLN_EDIT.CHANGE_JOIN_POS (
   name     VARCHAR2
   hintno   NUMBER
   newpos   NUMBER);

Parameters

Table 67-2 CHANGE_JOIN_POS Procedure Parameters

Parameter	Description
`name`	Name of the private outline to be modified.
`hintno`	Hint number to be modified.
`newpos`	New join position for the target hint.

CREATE_EDIT_TABLES Procedure

This procedure creates outline editing tables in calling a user's schema.

Syntax

DBMS_OUTLN_EDIT.CREATE_EDIT_TABLES;

Usage Notes

Beginning with Oracle Database 10g Release 1 (10.1) you will not need to use this statement because the outline editing tables will already exist as temporary tables in the SYSTEM schema.

DROP_EDIT_TABLES Procedure

This procedure drops outline editing tables in calling the user's schema.

Syntax

DBMS_OUTLN_EDIT.DROP_EDIT_TABLES;

GENERATE_SIGNATURE Procedure

This procedure generates a signature for the specified SQL text.

Syntax

DBMS_OUTLN.GENERATE_SIGNATURE ( 
   sqltxt      IN   VARCHAR2, 
   signature   OUT  RAW);

Parameters

Table 67-3 GENERATE_SIGNATURE Procedure Parameters

Parameter	Description
`sqltxt`	The specified SQL.
`signature`	The signature to be generated.

REFRESH_PRIVATE_OUTLINE Procedure

This procedure refreshes the in-memory copy of the outline, synchronizing its data with the edits made to the outline hints.

Syntax

DBMS_OUTLN_EDIT.REFRESH_PRIVATE_OUTLINE ( 
   name  IN  VARCHAR2);

Parameters

Table 67-4 REFRESH_PRIVATE_OUTLINE Procedure Parameters

Parameter	Description
`name`	Name of the private outline to be refreshed.