Oracle OUTLN_EDIT_PKG
Version 12.1.0.1

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 11.2.0.3 to 12.1.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.
Purpose Contains functional interface for procedures and functions associated with management of private outlines

Deprecation Notice: Outlines are deprecated as of 12cR1: Instead use baselines
AUTHID CURRENT_USER
Dependencies
DBMS_ASSERT DBMS_OUTLN_LIB DBMS_STANDARD
DBMS_OUTLN_EDIT    
Documented No
First Available 9.0.1
Security Model Owned by SYS with EXECUTE granted to PUBLIC and to the DBA and EXECUTE_CATALOG_ROLE roles
Source {ORACLE_HOME}/rdbms/admin/dbmsol.sql
Synonym DBMS_OUTLN_EDIT
Subprograms
CHANGE_JOIN_POS DROP_EDIT_TABLES REFRESH_PRIVATE_OUTLINE
CREATE_EDIT_TABLES GENERATE_SIGNATURE  
 
CHANGE_JOIN_POS
Change the join position for the hint identified by outline name and hint number to the position specified by newpos outln_edit_pkg.change_join_pos(
name   IN VARCHAR2,
hintno IN NUMBER,
newpos IN NUMBER);
TBD
 
CREATE_EDIT_TABLES
Create outline editing tables in calling user's schema outln_edit_pkg.create_edit_tables;
exec outln_edit_pkg.create_edit_tables;
 
DROP_EDIT_TABLES
Drop outline editing tables in calling user's schema outln_edit_pkg.drop_edit_tables;
exec outln_edit_pkg.drop_edit_tables;
 
GENERATE_SIGNATURE
Generates a signature for the specified SQL text outln_edit_pkg.generate_signature(sqltxt IN VARCHAR2, signature OUT RAW);
set serveroutput on

DECLARE
 x RAW(32767);
BEGIN
  outln_edit_pkg.generate_signature('SELECT user FROM dual', x);
  dbms_output.put_line(x);
END;
/
 
REFRESH_PRIVATE_OUTLINE
Refresh the in-memory copy of the outline, synchronizing its data with the edits made to the outline hints outln_edit_pkg.refresh_private_outline(name IN VARCHAR2);
exec outln_edit_pkg.refresh_private_outline('OL_DEMO');

Related Topics
DBMS_SPM
Outlines
OUTLN_PKG
Packages
Tuning

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved