Re: Program interacting with SQL*Plus
Date: Wed, 03 Jul 2002 15:05:26 -0400
Message-ID: <3D234AF6.70601_at_cs.uvm.edu>
Sybrand Bakker wrote:
> Theoretically speaking (never tried it, and I also can't see why you
> want to do it)
>
> mknod p orapipe
>
> sqlplus .... < orapipe &
>
> echo > orapipe
> or
> cat filename > orapipe
>
> Isn't this just very cumbersome and prone to error?
You're probably right. It is a poor man's solution. However it allows me access to a another programming language that I already have written some tools with. It's a quick glue job and gets the job done for now.
I found exec_with_piped.c at
http://www.pobox.com/~oleg/ftp/Communications.html#sh-agents
which seems to do what I need for now.It "is a tool that turns any UNIX-interactive application into a server, which runs as a single background process accepting sequences of commands from a number of clients (applications or scripts)."
Thanks,
David
> Regards
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Wed Jul 03 2002 - 21:05:26 CEST