Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to print logs in unix prompt or to a log file?
Top Forums Shell Programming and Scripting How to print logs in unix prompt or to a log file? Post 302671047 by vel4ever on Friday 13th of July 2012 03:46:48 AM
Old 07-13-2012
How to print logs in unix prompt or to a log file?
I am executing a stored procedure through shell script. In the procedure, i have dbms_output.put_line to log the comments. This is working fine and but logs are available only after the execution of the pl/sql procedure's completion.

I want to print the log comments while executing the procedure itself. is there a way to do it?

---------- Post updated at 02:46 AM ---------- Previous update was at 02:03 AM ----------

Shell script

Code:
logs=$root"/logs"
DATE=`date '+%Y%m%d'`
exec >> $logs/subprod_${DATE}.log 2>&1
sqlplus -s $user/$pass@$tns @$sql/inv_proce.sql << EOF
EOF

SQL file (nv_proce.sql )
Code:
set pages 0
set trimspool on
set serveroutput on
set echo on
set feedback on
set heading on
variable out NUMBER
begin
        pack.proce(:out);
end;
/

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

script to constantly read the last 500 new logs in a log file

Hello, I would like to write a bash script that would monitor a log file for a certain number of logs, let's say 500 logs and when it reaches that number to write the last log to another file. For example, I want to watch the /var/adm/messages and everytime, there is 500 new logs that are... (1 Reply)
Discussion started by: Pouchie1
1 Replies

2. UNIX Desktop Questions & Answers

Can Unix access Windows' File through Command Prompt in Unix

Hi all, I wish to know whether Unix can access window's file in Unix's terminal? Apart from that, how to copy files or share files between Window and Unix? I get to know of secure copy, however, my company's Unix does not support the feature of secure copy? Any other method for me to share/... (5 Replies)
Discussion started by: jessy83
5 Replies

3. Shell Programming and Scripting

Redirect all logs files contents into a single log file

Hi , I have a Data cleansing process which creates different log file for each step , when the process runs it creates following log files in below order: p1_tranfrmr_log.txt p1_tranfrmr_stats.txt p2_globrtr_log.txt p2_globrtr_stats.txt p3_cusparse_log.txt p3_cusparse_stats.txt ' '... (8 Replies)
Discussion started by: sonu_pal
8 Replies

4. Shell Programming and Scripting

Help needed to extract distinct logs from a Log File

Hi, I urgently need some help how to extract distinct entries from a Log file. The Log File may have same error occuring many times so how do i count the occurance of an error in file and also extract out distinct errors in a file. Eg:- I have a file name A.log it contains entries as below:-... (5 Replies)
Discussion started by: roro
5 Replies

5. UNIX for Dummies Questions & Answers

How to Change the % prompt to - prompt in UNIX?

how to Change the % prompt to - prompt in unix :wall: ---------- Post updated at 07:40 AM ---------- Previous update was at 07:38 AM ---------- How To display the last modification time of any file in unix ---------- Post updated at 07:40 AM ---------- Previous update was at 07:40 AM... (2 Replies)
Discussion started by: manjiri sawant
2 Replies

6. UNIX for Dummies Questions & Answers

File transmission logs in UNIX

Can any one give a explaination with examples on how to understand file transmission log files in Unix for inbound and outbound traffic. (1 Reply)
Discussion started by: ITDev01
1 Replies

7. UNIX for Dummies Questions & Answers

Problem with UNIX logs file

I'm working on Logs Management System. it requires from all Unix servers to send their logs files to a specific (IP, Port). Please help me to get the right conf on logs files to send them to that IP and port. Any suggestions are highly appreciated. :o:o (0 Replies)
Discussion started by: kinan adra
0 Replies

8. Solaris

How to print the particular date logs on UNIX (Solaris)?

I would like to get only some particular date logs from /var/adm/messages. Please suggest any command or script to get this. (3 Replies)
Discussion started by: seenuvasan1985
3 Replies

9. Shell Programming and Scripting

Need help in getting the Last 30 minutes logs from the Log File

I have a log file with the below contents : log_file_updated.txt : Jul 5 03:33:06 rsyslogd: was Jul 5 03:33:09 adcsdb1 rhsmd: This system is registered. Sep 2 02:45:48 adcsdb1 UDSAgent: 2015-07-05 04:24:48.959 INFO Worker_Thread_4032813936 Accepted connection from host <unknown>... (3 Replies)
Discussion started by: rahul2662
3 Replies

10. UNIX for Beginners Questions & Answers

Print Error in Console and both Error & Output in Log file - UNIX

I am writing a shell script with 2 run time arguments. During the execution if i got any error, then it needs to redirected to a error file and in console. Also both error and output to be redirected to a log file. But i am facing the below error. #! /bin/sh errExit () { errMsg=`cat... (1 Reply)
Discussion started by: sarathy_a35
1 Replies

LEARN ABOUT REDHAT

getbuildlog

GETBUILDLOG(1)						      General Commands Manual						    GETBUILDLOG(1)

NAME

       getbuildlog - download build logs from Debian auto-builders

SYNOPSIS

       getbuildlog package [version-pattern] [architecture-pattern]

DESCRIPTION

       getbuildlog downloads build logs of package from Debian auto-builders. It downloads build logs of all versions and for all architectures if
       version-pattern and architecture-pattern are not specified or empty, otherwise only build logs whose  versions  match  version-pattern  and
       build  logs  whose  architectures  match  architecture-pattern will be downloaded. The version and architecture patterns are interpreted as
       extended regular expressions as described in grep(1).

       If version-pattern is "last" then only the logs for the most recent version of package found on buildd.debian.org will be downloaded.

       If version-pattern is "last-all" then the logs for the most recent version found on each build log index will be downloaded.

OPTIONS

       -h, --help
	      Show usage information and examples.

       -V, --version
	      Show version and copyright information.

EXAMPLES

       getbuildlog hello 2.2-1 amd64
	      Download amd64 build log for hello version 2.2-1.

       getbuildlog glibc "" mips.*
	      Download mips(el) build logs of all glibc versions.

       getbuildlog wesnoth .*bpo.*
	      Download all build logs of backported wesnoth versions.

AUTHOR

       Written by Frank S. Thomas <fst@debian.org>.

DEBIAN
								 Debian Utilities						    GETBUILDLOG(1)
All times are GMT -4. The time now is 05:15 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy