Re: Piping Unix output to SQL*plus

In article <94l2ue$onc$1_at_nnrp1.deja.com>, venkat_rajagopal_at_my-deja.com says...

> $ cat test.sql
>
> SET FEEDBACK OFF
>
> SELECT value
> FROM v$parameter
> WHERE name = '&&X';
 

>
> I want the script to prompt for x, then exit.

I know someone else has already asked this, but it's scrolled since I last looked. Why can't you simply?

sqlplus -s / @test.sql

?

If I remember right, that was the part of the app you said couldn't be reworked. Can you give a little more details on the app itself? If it's general shell scripting, I can certainly help make any needed mods...

Doug

-- 
-------------------
Douglas K. O'Leary
Senior System Admin
dkoleary_at_mediaone.net