René Nyffenegger's collection of things on the web | |
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
The most simple adpoci programm | ||
This programm tries to connect to a database and waits then for a key to be hit. The created session can then be viewed in
v$session. If this works, use the create table example.
This programm uses adpoci to be able to compile it.
Be sure to first compile and link the library into a shared library or dll.
After doing so, the programm can be compiled and linked like so
On Linux with gcc: gcc -I##A($ORACLE_HOME,/ora/misc/env_vars.html#oracle_home/rdbms/demo -I$ORACLE_HOME/rdbms/public first.c -o first -L. -L$ORACLE_HOME/lib -ladpoci -lclntsh
On Windows with mingw:
gcc -I%ORACLE_HOME%\oci\include first.c -o first.exe -L. -ladpoci %ORACLE_HOME%\bin\oci.dll Usage./first username/password@db first.c#include <oci.h> #include <stdio.h> #include <stdlib.h> #include "adpoci.h" int main(int argc, char* argv[]) { char err_msg [512]; sword r; struct oci_connection conn; if (argc < 2) { printf("usage %s username/password[@dbname]\n", argv[0]); exit (-1); } text username[30]; text password[30]; text dbname [30]; parse_connect_string(argv[1],username, password, dbname); if (!oci_connect(username, password, dbname,&conn, err_msg)) { printf(err_msg); goto clean_up; } printf("A connection has been established and should be visible\n"); printf("in the v$session view.\n"); getc(stdin); clean_up: OCITerminate(OCI_DEFAULT); return 0; } |