Summary of DBMS_OUTLN_EDIT Subprograms

Table 42-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.
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 42-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;

DROP_EDIT_TABLES Procedure

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

Syntax

DBMS_OUTLN_EDIT.DROP_EDIT_TABLES;

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 42-3 REFRESH_PRIVATE_OUTLINE Procedure Parameters

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