Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Piping from Unix to SQL*Plus
> 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).
What you are asking for does not work. SQLPLUS does not accept input this way. I would suggest that you redesign your product. This simplest is to pipe your output to a file, then envoke SQLPLUS as suggested earlier. This is normally done with a wrapper.
HTH,
Brian
-- ======================================== Brian Peasland Raytheons Systems at USGS EROS Data Center These opinions are my own and do not necessarily reflect the opinions of my company! ========================================Received on Mon Jan 22 2001 - 08:31:06 CST