60
DBMS_OUTLN_EDIT

The DBMS_OUTLN_EDIT package is an invoker's rights package.

See Also: For more information about using the DBMS_OUTLN_EDIT package, see UsingPlan Stability in Oracle Database Performance Tuning Guide.

This chapter contains the following topic:

• Summary of DBMS_OUTLN_EDIT Subprograms

---

Summary of DBMS_OUTLN_EDIT Subprograms

Table 60-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 60-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 release 10i 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 60-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 60-4 REFRESH_PRIVATE_OUTLINE Procedure Parameters

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