CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle OUTLN_EDIT_PKG
Version 11.1
 
General
Note: Contains functional interface for procedures and functions associated with management of private outlines
Source {ORACLE_HOME}/rdbms/admin/dbmsol.sql
First Available 9.0.1
Dependencies
DBMS_ASSERT DBMS_OUTLN_EDIT DBMS_OUTLN_LIB DBMS_SQLTCB_INTERNAL
Security Model Execute is granted to DBA, OUTLN and EXECUTE_CATALOG_ROLE roles
Synonym DBMS_OUTLN_EDIT
 
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
Outlines
OUTLN_PKG
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [115 users online]    © 2010 psoug.org