dbTalk Databases Forums  

C source code for Oracle connection

comp.databases comp.databases


Discuss C source code for Oracle connection in the comp.databases forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
elekaj34
 
Posts: n/a

Default C source code for Oracle connection - 06-01-2006 , 04:30 AM






Hi everybody,

Where can I found a C source code for conecting to Oracle database ?

My gaol is to write a little program which extract some tables and
convert them to CSV file.
This program will run on Linux (Oracle instantclient 10.2 and SQL*Plus
is installed on this machine)

Thank you in advance for your help

Elekaj.

Reply With Quote
  #2  
Old   
Jim Kennedy
 
Posts: n/a

Default Re: C source code for Oracle connection - 06-01-2006 , 08:20 AM







"elekaj34" <elekaj34 (AT) free (DOT) fr> wrote

Quote:
Hi everybody,

Where can I found a C source code for conecting to Oracle database ?

My gaol is to write a little program which extract some tables and
convert them to CSV file.
This program will run on Linux (Oracle instantclient 10.2 and SQL*Plus
is installed on this machine)

Thank you in advance for your help

Elekaj.
You should find some simple examples at otn.oracle.com. You should also
find some simple examples where you install the regular client. (developer's
choices) You can use the instant client, but the instant client isn't going
to have the C examples, C header files, the lib files etc. But you can
write the code compile it and put the result on another machine that only
has an instant client.
Jim




Reply With Quote
  #3  
Old   
David Cressey
 
Posts: n/a

Default Re: C source code for Oracle connection - 06-01-2006 , 03:38 PM




"Jim Kennedy" <jim dot scuba dot kennedy at gee male dot com> wrote in
message news:T4idnanli5-EdOPZRVn-tg (AT) comcast (DOT) com...
Quote:
"elekaj34" <elekaj34 (AT) free (DOT) fr> wrote in message
news:447eb31f$0$2122$636a55ce (AT) news (DOT) free.fr...
Hi everybody,

Where can I found a C source code for conecting to Oracle database ?

My gaol is to write a little program which extract some tables and
convert them to CSV file.
This program will run on Linux (Oracle instantclient 10.2 and SQL*Plus
is installed on this machine)

Thank you in advance for your help

Elekaj.

You should find some simple examples at otn.oracle.com. You should also
find some simple examples where you install the regular client.
(developer's
choices) You can use the instant client, but the instant client isn't
going
to have the C examples, C header files, the lib files etc. But you can
write the code compile it and put the result on another machine that only
has an instant client.
Jim


To the OP:

Jim's advice sounds good.

If you still need help, you might be interested in a SQL*PLUS script that
unloads any given table or view
into a CSV file. Many people wrote such scripts. I'm one of them. I no
longer offer it on the web, but if you contact me, I could send you a copy.

My script used to be useful, back in Oracle version 7 times. I thought
later versions of Oracle had this functionality built in. Perhaps not.





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.