Pl sql procedure dbms output

Question

Is there anyway we can write/capture the dbms outputs in a log file? I have a procedure run from the program and it has dbms in it.. Where the output will be saved when executed? Please guide

You need to put an example of your code. Your question , without it, is too vague. — Andy K, Dec 28 '14 at 08:16
http://stackoverflow.com/questions/1453538/how-to-redirect-the-output-of-dbms-output-put-line-to-a-file — simplify_life, Dec 28 '14 at 11:00
What kind of program are you calling the procedure from? If it isn't something that supports this natively. e.g. via `set serveroutput on`, you'd need to extract the buffered output - it's stored in a buffer as the docs say, not saved in a table. ([This is one way](http://stackoverflow.com/a/19143017/266304), but it really depends on your client and what you want to do next). — Alex Poole, Dec 28 '14 at 18:11
Worse stuff man is that you could have easily find the answer, just by typing your question on the internet. — Andy K, Dec 29 '14 at 08:14

score 2 · Answer 1 · answered Dec 28 '14 at 08:15

2

Put SET SERVEROUTPUT ON;before the declare statement

answered Dec 28 '14 at 08:15

Andy K

4,944
10
53
82

score 2 · Answer 2 · answered Dec 31 '14 at 09:46

2

You need use SET SERVEROUTPUT ON

set serveroutput on
begin
dbms_output.put_line('something to write')
end;

answered Dec 31 '14 at 09:46

starko

1,150
11
26

May i know where in server, these logs will be written – GKN Feb 16 '15 at 14:45

score 1 · Accepted Answer · answered Dec 29 '14 at 13:52

As already said you'll have to include a SET SERVEROUTPUT ON; statement before your DECLARE but you'll also need to handle the output on the OS level:
sqlplus -s user/pword@db '@script.sql;' > log.txt
Hint: the -s flag will hide the sqlplus version info from your log file.

Pl sql procedure dbms output

3 Answers3