DBMS_OUTPUT.PUT_LINE doesn't print values in shell script Post: 303039022

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell script doesn't get executed using crontab

I have the following crontab entry to run a shell script for every 30 minutes of every day: 30 * * * * $HOME/main.sh > $HOME/main.log 2>$HOME/error.log after I created the crontab file I have also done: $crontab my_crontab I also check to make sure it exists, by using the following...

2. Shell Programming and Scripting

sqlplus and dbms_output.put_line in shell script

Hi, I have created a pl/sql block utilises dbms_output.put_line. This script works fine when I call from sqlplus ie sqlplus @./scriptname but when I embed it within my shell script I get no output to screen so I end up with an empty spool file. I know it's executing successfully when called from...

3. Shell Programming and Scripting

shell script, echo doesn't work

#!/bin/sh something(){ echo "Inside something" echo $1 $2 } val=$(something "Hello " "world") Output expected: Inside somethingHello world But it's not echoing.

4. Programming

How to Format database output (DBMS_OUTPUT.PUT_LINE) in unix?

Dear All, As I'm new here, please forgive me if any rule violation occurred. I have a script like this: #! /bin/ksh # Author : Saptarshi # Date : 18-Mar-2011 # Version : 1.0 Return_op=`sqlplus -s <<ENDOFSQL db_user/db_pass@db_nm WHENEVER SQLERROR EXIT 1 set ...

5. Shell Programming and Scripting

[Solved] How to display only output of DBMS_OUTPUT.PUT_LINE , rest should be neglected

Hi All, I Have written a script through that i am calling sql file Sqlfile.sql set time on set timing on set echo on set head off set scan on set feedback on set serveroutput on set linesize 1000 DECLARE v_acc_no NUMBER(10); v_product_no NUMBER(10); BEGIN...

6. Shell Programming and Scripting

Query the table and return values to shell script and search result values from another files.

Hi, I need a shell script, which would search the result values from another files. 1)execute " select column1 from table_name" query on the table. 2)Based on the result, need to be grep from .wft files. could please explain about this.Below is the way i am using. #!/bin/sh...

7. Shell Programming and Scripting

Script doesn't print error.

Hi Gurus, I have below sample script. I expect it print error when running script without input parameter. but the it doesn't. would you please help me about this issue. thanks in advance. /script$cat test.ksh #!/bin/ksh while getopts :f: arg do case $arg in ...

8. UNIX for Dummies Questions & Answers

Reading XML file and print the values in the text file using Linux shell script

hi guys, i want help... Reding XML file and print the values into the text file using linux shell script file as per below xml file <sequence> <Filename>aldorzum.doc</Filename> <DivisionCode>US</DivisionCode> <ContentType>Template</ContentType> <ProductCode>VIMZIM</ProductCode> </sequence>...

9. Shell Programming and Scripting

The shell script doesn't get arguments, but parse them

Hello, I have a simple shell script, which starts from crontab like this: 00 03 * * 2-6 /export/applications/dte/sh/fwmarg.sh > /export/applications/dte/data/cron_log/fwmarg.cronlog.`date +\%m.\%d` 2>&1 The script doesn't get any argument. But inside it I see the line ...

LEARN ABOUT CENTOS

arping

ARPING(8)						 System Manager's Manual: iputils						 ARPING(8)

NAME

       arping - send ARP REQUEST to a neighbour host

SYNOPSIS

       arping [-AbDfhqUV] [-c count] [-w deadline] [-s source] -I interface destination

DESCRIPTION

       Ping destination on device interface by ARP packets, using source address source.

OPTIONS

       -A     The same as -U, but ARP REPLY packets used instead of ARP REQUEST.

       -b     Send only MAC level broadcasts. Normally arping starts from sending broadcast, and switch to unicast after reply received.

       -c count
	      Stop  after  sending  count  ARP	REQUEST packets. With deadline option, arping waits for count ARP REPLY packets, until the timeout
	      expires.

       -D     Duplicate address detection mode (DAD). See RFC2131, 4.4.1.  Returns 0, if DAD succeeded i.e. no replies are received

       -f     Finish after the first reply confirming that target is alive.

       -I interface
	      Name of network device where to send ARP REQUEST packets.

       -h     Print help page and exit.

       -q     Quiet output. Nothing is displayed.

       -s source
	      IP source address to use in ARP packets.	If this option is absent, source address is:

	      o In DAD mode (with option -D) set to 0.0.0.0.

	      o In Unsolicited ARP mode (with options -U or -A) set to destination.

	      o Otherwise, it is calculated from routing tables.

       -U     Unsolicited ARP mode to update neighbours' ARP caches.  No replies are expected.

       -V     Print version of the program and exit.

       -w deadline
	      Specify a timeout, in seconds, before arping exits regardless of how many packets have been sent or received. In	this  case  arping
	      does not stop after count packet are sent, it waits either for deadline expire or until count probes are answered.

SEE ALSO

       ping(8), clockdiff(8), tracepath(8).

AUTHOR

       arping was written by Alexey Kuznetsov <kuznet@ms2.inr.ac.ru>.  It is now maintained by YOSHIFUJI Hideaki <yoshfuji@skbuff.net>.

SECURITY

       arping  requires  CAP_NET_RAW capability to be executed. It is not recommended to be used as set-uid root, because it allows user to modify
       ARP caches of neighbour hosts.

AVAILABILITY

       arping is part of iputils package and the latest versions are   available  in  source  form  at	http://www.skbuff.net/iputils/iputils-cur-
       rent.tar.bz2.

iputils-121221							   10 June 2014 							 ARPING(8)