| DBMS_OUTPUT package and "set serveroutput on" command [message #302182] |
Sun, 24 February 2008 14:20  |
batitou81
Messages: 11
Registered: February 2008
|
Junior Member |
|
|
hi everybody
my name is Baptiste, I'm a french student and I'm interested about Oracle Technologies.
Now, I have a problem.
I want to create a trigger, and when a user logon, "SET SERVEROUTPUT ON" command must be activate.
So how can I do that?
I have made some search about the dbms_output package, but I don't found anything intersting for my request.
Is anyone can help me ?
Thanks!
|
|
|
|
| Re: DBMS_OUTPUT package and "set serveroutput on" command [message #302183 is a reply to message #302182] |
Sun, 24 February 2008 14:33  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
>I want to create a trigger, and when a user logon, "SET SERVEROUTPUT ON" command must be activate.
Forgive me, but this makes NO sense.
>"SET SERVEROUTPUT ON"
Above is a SQL*Plus command; which does not come into play inside a trigger.
A trigger runs deep inside the database engine & has no direct way to "talk" to the user invoking the trigger.
[Updated on: Sun, 24 February 2008 14:33] by Moderator Report message to a moderator |
|
|
|
|
|
| Re: DBMS_OUTPUT package and "set serveroutput on" command [message #302191 is a reply to message #302183] |
Sun, 24 February 2008 16:17 |
batitou81
Messages: 11
Registered: February 2008
|
Junior Member |
|
|
| anacedent wrote on Sun, 24 February 2008 14:33 | >I want to create a trigger, and when a user logon, "SET SERVEROUTPUT ON" command must be activate.
Forgive me, but this makes NO sense
|
Scuse me...
In fact, I use iSQLplus, and when I build a PL/SQL request with
"dbms_output.put_line", I'm oblige to add: set serveroutput ON.
Now, I want that this command "set serveroutput on" will be automaticaly made when an user log on.
So, I must to use a trigger.
does it make any sense?
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
