Re: Piping from Unix to SQL*Plus

From: Avi Abrami <aabrami_at_intersystemsww.com>
Date: Tue, 23 Jan 2001 07:17:09 +0200
Message-ID: <3A6D13D5.9BACFA74@intersystemsww.com>

Venkat,
What exactly is your problem with '&&' in file 'filename'? Do you want to ignore occurrences of '&&'? Do you want to somehow supply values for them? Or what? The solution of-course, will depend on your answer. I think trying to guess is just a waste of energy (for me).

Cheers,
Avi.

venkat_rajagopal_at_my-deja.com wrote:

> In article <0ulh6tc6p2vom94havlkfh8vpc7peqhmv3_at_4ax.com>,
> kasten_at_pobox.com wrote:
> > venkat_rajagopal_at_my-deja.com allegedly wrote:
> >
> > > Hi,
> > >
> > > I've got a problem. I want to pipe a file ( all sql*plus commands
> > > inside the file ) to sqlplus .
> > >
> > > cat filename | sqlplus -s /
> > >
> > > is ok but won't work for me because in my file 'filename'
> > > I have '&&' specified in order to accept user input.
> > > The above method is ok if I don't have the need for user input.
> > > How can I do this? You might be wondering why on earth I need it
> > > but I really do. Let me know if you guys have any suggestions
> > > and If needed and you so desire I will give you more details.
> > >
> > > Thanks
> > >
> > > Venkat
> > >
> > >
> > > Sent via Deja.com
> > > http://www.deja.com/
> >
> > If these are all commands in the file, just do a:
> >
> > sqlplus user/passw_at_dbsid @filename

>

> Chris,

>

> That is the most obvious but I cannot use that in my case. I
> have a design need for Unix output to be piped to sqlplus when
> the file contains SQLPLUS commands and 'ampersands' (to accept
> user input).

>

> Venkat
> >
> > and stand back and watch it go.
> > --
> > Chris Kasten
> > icq# 7603936
> > http://www.kastenracing.com/chris/
> >

>

> Sent via Deja.com
> http://www.deja.com/
Received on Mon Jan 22 2001 - 23:17:09 CST