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

spectool

SPECTOOL(1)							   User Commands						       SPECTOOL(1)

NAME

       spectool - manual page for spectool v1.0.10rpmdev1

SYNOPSIS

       spectool [<options>] <specfile>

DESCRIPTION

       Spectool is a tool to expand and download sources and patches from specfiles.

       If you experience problems with specific specfiles, try to run

	      rpmbuild --nobuild --nodeps <specfile>

       on  the	file which might give a clue why spectool fails on a file (ignore anything about missing sources or patches). The plan is to catch
       errors like this in spectool itself and warn the user about it in the future.

OPTIONS

   Operating mode:
       -l, --lf, --list-files
	      lists the expanded sources/patches (default)

       -g, --gf, --get-files
	      gets the sources/patches that are listed with a URL

       -h, --help
	      display this help screen

   Files on which to operate:
       -A, --all
	      all files, sources and patches (default)

       -S, --sources
	      all sources

       -P, --patches
	      all patches

       -s, --source x[,y[,...]]
	      specified sources

       -p, --patch a[,b[,...]]
	      specified patches

   Miscellaneous:
       -d, --define 'macro value'
	      defines RPM macro 'macro' to be 'value'

       -C, --directory dir
	      download into specified directory (default '.')

       -R, --sourcedir
	      download into rpm's %{_sourcedir}

       -n, --dryrun, --dry-run
	      don't download anything, just show what would be done

       -f, --force
	      try to unlink and download if target files exist

       -D, --debug
	      output debug info, don't clean up when done

FILES

       /etc/rpmdevtools/curlrc

	      optional curl(1) configuration

spectool v1.0.10rpmdev1 					     June 2014							       SPECTOOL(1)