I'm looking to write a command-line program that can execute database scripts against an Oracle server, however the machine the program will be run on may not have an Oracle client installed on it. I also don't want to rely on a language that requires a VM as there's no guarantee that the VM will be installed, so a language like C is preferable for this. Is there a way that I can statically compile/build this program and not have to have the user install the Oracle client on that machine? I'm trying to be as unobtrusive as possible.
Thanks.
My first guess was to use JDBC (type 4 driver) since you do not want a VM based language, it is out of the question.
SO, I think you should take a look at instant client
http://www.oracle.com/technology/tech/oci/instantclient/index.html
(thanks to google)