| 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 |
|
|
| 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 VARCHAR2,
hintno NUMBER,
newpos 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 |
| Undocumented |
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 VARCHAR2); |
| exec outln_edit_pkg.refresh_private_outline('ol_demo'); |