| 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'); |
