sql script not showing output when run from UNIX CLI

Question

following script is stored in file myscript

when i run it as oracle from UNIX CLI :

$./myscript 1234 2345

it does not show any output, but when i run the commands individually on the SQL prompt, they run fine and produce output.

can anyone help, why no output from UNIX CLI?

#!/bin/ksh
startDt=$1
endDt=$2
sqlplus mysqlroot/mysqlroot <<EOF >/dev/null
        SET TRIMOUT ON;
        SET FEEDBACK  OFF;
        SET PAGESIZE  0;
        SET VERIFY    OFF;
        set linesize 2300;
        set colsep |;
    select * from my_sales where saleTIME >= $startDt and saleTIME<= $endDt;
        exit;
EOF

Get rid of >/dev/null.

Jaugar Chang
– Jaugar Chang

2014-09-02 05:39:18 +00:00
Commented Sep 2, 2014 at 5:39 — Jaugar Chang
– Jaugar Chang, Commented Sep 2, 2014 at 5:39

paxdiablo · Accepted Answer · 2014-09-02 05:39:19Z

3

sqlplus mysqlroot/mysqlroot <<EOF >/dev/null
    blah blah blah
EOF

You're sending the standard output to the /dev/null device, the "bit bucket" where everything is thrown away.

This is best illustrated with the following transcript, where redirecting to /dev/null causes output to not appear:

pax> echo xyzzy >/dev/null
pax> echo xyzzy
xyzzy
pax> _

If you don't want it thrown away, just remove that output redirection:

sqlplus mysqlroot/mysqlroot <<EOF
    blah blah blah
EOF

answered Sep 2, 2014 at 5:39

paxdiablo

888k243 gold badges1.6k silver badges2k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Rajeev Over a year ago

thank you. sometimes it is right in front of you and you miss it.

Collectives™ on Stack Overflow

sql script not showing output when run from UNIX CLI

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related