| General Information |
| Library Note |
Morgan's Library Page Header
|
| Purpose |
Database Vault Output Buffer Utilities |
| AUTHID |
DEFINER |
| Dependencies |
| DV$OUT |
OUT |
PLITBLM |
| KZV$UTL_LIBT |
|
|
|
| Documented |
No |
| First Available |
12.1 |
| Security Model |
Owned by DVSYS with EXECUTE granted to the DV_ADMIN role. |
| Source |
{ORACLE_HOME}/rdbms/admin/catmacp.sql |
| Subprograms |
|
| |
| DISABLE |
| Disables buffer output |
dbms_macout.disable; |
See GET_LINE Demo Below |
| |
| ENABLE |
| Enables buffer output |
dbms_macout.enable; |
See GET_LINE Demo Below |
| |
| GET_LINE |
| Returns a line of text from the buffer |
dbms_macout.get_line(n IN NUMBER) RETURN VARCHAR2; |
DECLARE
retVal VARCHAR2(60);
BEGIN
dvsys.dbms_macout.enable;
dvsys.dbms_macout.put_line('Morgan');
dbms_output.put_line( dvsys.dbms_macout.get_line_count);
retVal := dvsys.dbms_macout.get_line(1);
dbms_output.put_line(retVal);
dvsys.dbms_macout.disable;
END;
/
2
Morgan
PL/SQL procedure successfully completed. |
| |
| GET_LINE_COUNT |
| Returns the number of lines in the buffer |
dbms_macout.get_line_count RETURN NUMBER; |
See GET_LINE Demo Above |
| |
| IS_ENABLED |
| Returns TRUE if tracing is enabled: Otherwise FALSE |
dbms_macout.is_enabled RETURN BOOLEAN; |
BEGIN
IF dvsys.dbms_macout.is_enabled THEN
dbms_output.put_line('T');
ELSE
dbms_output.put_line('F');
END IF;
END;
/
F
PL/SQL procedure successfully completed. |
| PL |
| Add a new line of text to the output buffer ... the same as PUT_LINE |
dbms_macout.pl(s IN VARCHAR2); |
exec dvsys.dbms_macout.pl('MLib');
PL/SQL procedure successfully completed. |
| |
| PUT_LINE |
| Add a new line of text to the output buffer |
dbms_macout.put_line(s IN VARCHAR2); |
See GET_LINE Demo Above |