Re: sqlplus within the unix shell
From: Michel Cadot <micadot_at_netcourrier.com>
Date: Thu, 6 Jan 2000 09:33:52 +0100
Message-ID: <851k1p$ul2$1_at_news4.isdnet.net>
Date: Thu, 6 Jan 2000 09:33:52 +0100
Message-ID: <851k1p$ul2$1_at_news4.isdnet.net>
Here's a script from Kenneth C Stahl <BlueSax_at_Unforgettable.com> that works fine for that:
#!/bin/ksh
MyVar=$(sqlplus -s system/manager <<sqlEOF
whenever sqlerror exit failure;
set feedback off;
set pages 0;
variable id number;
begin
select 1
into :id
from dual;
end;
.
/
print id
exit success;
sqlEOF)
print -u1 $MyVar;
exit 0;
-- Have a nice day Michel Eugene Firyago <efiryago_at_bisys.com> a écrit dans le message : 850f5b$m52$1_at_bob.news.rcn.net...Received on Thu Jan 06 2000 - 09:33:52 CET
> Is it possible the unix shell to see/handle the result as sqlplus variables
> of a sqlplus script run from within a shell script?
>
> Thanks in advance,
> Eugene.
>
>
>