Re: Q: Howto setup SQL*Plus as a listener daemon on Solaris 2.5 oracle 7.3.3

From: M.W. van Nijnanten <nijnanten_at_xs4all.nl>
Date: 1997/10/14
Message-ID: <3443E297.275808F@xs4all.nl>#1/1

Bo Meyer wrote:
Hello Bo,

> Does anyone have a hint to solve my problem?
>
> I am trying to start SQL*Plus in the background and read input from a
> device:
>

I've done some experiments on this subject, but that was some time ago so forgive me if I'm wrong.

> mknod /dev/sql p
> cat /dev/sql | sqlplus -s u/p &
>

When "cat" reaches the end of file it terminates, it might be better to use "tail -f /dev/sql" instead.

> and then
>
> echo "select * from tab" > /dev/sql
>
> The first statement are executed fine, hereafter the background job
> stops.
> I have to keep SQL*Plus up as a deamon, for echo of 10-20 sql
> statements.
>
> Best regards,
>
> Bo Meyer
> mailto:bmeyer_at_relief.dk

You can spool your output to (a) different pipe(s).For security reasons I deleted the input pipe as soon as it was in use. This worked fine in my experiments.

I hope I've helped.

Maarten van Nijnanten

(If you want to reply replace ij with y.) Received on Tue Oct 14 1997 - 00:00:00 CDT