| General Information |
| 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 |
|
| Security Model |
Execute is granted to DBA, OUTLN and EXECUTE_CATALOG_ROLE roles |
| Subprograms |
| CHANGE_JOIN_POS |
DROP_EDIT_TABLES |
REFRESH_PRIVATE_OUTLINE |
| CREATE_EDIT_TABLES |
GENERATE_SIGNATURE |
|
|
| 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'); |
