Re: Calling sqlplus or plsql code from ksh

The code below is good, but I am fairly certain there is the potential security risk that someone on the same Unix machine could do a ps command and see the process and it's commands, such as the username/password .

To hide this, you can pass it as the first line with no connect command ... doing this from memory but I am fairly certain this revised code would hide this info:

sqlplus -s >/dev/null 2>&1 <<EOF
monitor/oramon

   whenever sqlerror exit 1
   select * from dual;

• If we can not connect or select, we will not return 0!!! exit 0 EOF

-- 

"Snid" <snid_at_snider.sno> wrote in message
news:c144ao$6a5$1_at_bunyip.cc.uq.edu.au...


> Check out the sqlplus line

>

> sqlplus -s >/dev/null 2>&1 "monitor/oramon" <<EOF

>    whenever sqlerror exit 1

>    select * from dual;

>    -- If we can not connect or select, we will not return 0!!!

>    exit 0

> EOF

>

>

> http://www.orafaq.com/scripts/unix/wait4ora.txt

>

> More scripts here

> http://www.orafaq.com/scripts/index.htm#UNIX

>

>

>

> <capitaldog_at_hotmail.com> wrote in message

> news:cc72d8ab.0402191948.49c839c8_at_posting.google.com...

> | Can you guys show me some of the ways to run sql code from ksh scripts.

> |

> | Thanks,

> | dog

>

>