Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: sqlplus instead of PRO*C for simple DB queries from C?

Re: sqlplus instead of PRO*C for simple DB queries from C?

From: Branko Koprivica <perpetum_at_interlog.com>
Date: Sat, 02 Jan 1999 15:30:49 -0400
Message-ID: <368E73E9.CF6F45A2@interlog.com>


Instead of creating a temporary file I would rather open a pipe between shell script and C process to exchange data

Branko Koprivica

Thomas Leitner wrote:

> Hi,
>
> I'm about to make plans for a simple utility running under Unix and
> written in C which should query numerical values from an Oracle DB,
> calculate some pretty graphics from it and show the graphics on the
> screen. There is not much user interaction required other than to
> start the program, look at the graphics.
>
> Now for the DB query, I think that PRO*C would be kind of an overkill.
> So I'm thinking of splitting the whole story into two parts: Part 1
> is a shell script which just fires off sqlplus with the appropriate SQL
> select command and spools the output into an intermediate file. There are
> not many rows to be queried so the file should not grow too large. The
> second part written in C just reads this file and processes the data.
>
> Question: Are there any arguments against an implementation like this?
>
> Thanks // Tom
> --
> Tom Leitner Dept. of Communications, Graz Univ. of Technology,
> tom_at_finwds01.tu-graz.ac.at Inffeldgasse 12, A-8010 Graz / Austria / Europe
> PGP public key @ http://wiis.tu-graz.ac.at/people/tom.html
Received on Sat Jan 02 1999 - 13:30:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US