is it possible to set serveroutput in a trigger?
452679Sep 7 2005 — edited Sep 8 2005I need to "set serveroutput on" in an after logon trigger. Is this possible? If so, can I have an example? I tried
CREATE OR REPLACE TRIGGER EG.test_setserveroutput
AFTER LOGON
ON DATABASE
BEGIN
place dbms_output.enable(100000);
END test_setserveroutput;
/
but got the following error:
PLS-00103: Encountered the symbol "DBMS_OUTPUT" when expecting one of the following:
:= . ( @ % ;
Any help would be appreciated.