Re: Calling sqlplus or plsql code from ksh

Do NOT top post replys/response...
(see more below)
capitaldog_at_hotmail.com wrote:
> ops, I meant how would you retrieve the data not the date.
>
> Thanks Again,
> Dog
>
> Stephan Bressler <sbresslerx_no_spam_at_arcor.de> wrote in message news:<c14cn3$kdf$1_at_news.mch.sbs.de>...
>

>>>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
>>>
>>
>>Or this way:
>>sqlplus -s /nolog >/dev/null 2>&1 <<EOF
>>connect monitor/oramon
>>_your_sql_statements_
>>EOF

"retrieve the data" is what a SELECT statement does.

What problem are you REALLY trying to solve? It does us no good to guess at what you really want. Received on Sun Feb 22 2004 - 18:26:56 CST