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

From: Thomas Leitner <tom_at_finwds01.tu-graz.ac.at>
Date: 28 Dec 1998 10:44:58 GMT
Message-ID: <767nfa$dfr@fstgal00.tu-graz.ac.at>

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 Mon Dec 28 1998 - 04:44:58 CST