Re: entering data from external program

The not so simple answer is...

Check out Oracle's pre-compilers - specifically PRO-C you should be able to include SQL inserts - that reference local variables into your C code.

(You could alternately try the OCI interface - but it is very low level. I don't recommend OCI unless you need that low level control.)

After you master simple row at a time inserts, you might then try array inserts to pass larger packets of records to the table from your app for efficiency if you are in a client server environment.

HTH Ken Nunes wrote in message <369f9d85.159709199_at_news2.cts.com>...
>Greetings,
>
> I have a numerical analysis app that generates a lot of data.
>How do I pipe this data into a table on my oracle8 server from within
>the app? The app is written in C.
>
>I guess the simple version of my question is: how do I make a C
>program that will insert data into a table.
>
>Any suggestions are greatly appreciated,
>
>Ken Nunes
Received on Fri Jan 15 1999 - 22:14:30 CST