dbTalk Databases Forums  

Accessing Oracle database on Solaris from C program

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss Accessing Oracle database on Solaris from C program in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
agalkin@audible.com
 
Posts: n/a

Default Accessing Oracle database on Solaris from C program - 02-22-2006 , 04:57 PM






I need to perform queries on Oracle database from C/C++ program on
Solaris. I have very extensive experience with C/C++ and MS Windows OS
but close to none with Solaris or Oracle. Our database adminstrator
told me that we do not have any documentation, he does not know if we
have any C libraries for accessing Oracle database. The only
information he provided me with is that we have Oracle version 9.2.0.7
(Oracle 9i) and Solaris 10. Any help with where to get Oracle C
libraries (header and lib files) and any sample source code how to
acess it would be greatly appreciated. If this is not the best
newsgroup to post such quiestion I would also like to know which one I
should post to.


Reply With Quote
  #2  
Old   
ianal Vista
 
Posts: n/a

Default Re: Accessing Oracle database on Solaris from C program - 02-22-2006 , 08:52 PM






agalkin (AT) audible (DOT) com wrote in news:1140649046.180179.144260
@g14g2000cwa.googlegroups.com:

Quote:
I need to perform queries on Oracle database from C/C++ program on
Solaris. I have very extensive experience with C/C++ and MS Windows OS
but close to none with Solaris or Oracle. Our database adminstrator
told me that we do not have any documentation, he does not know if we
have any C libraries for accessing Oracle database. The only
information he provided me with is that we have Oracle version 9.2.0.7
(Oracle 9i) and Solaris 10. Any help with where to get Oracle C
libraries (header and lib files) and any sample source code how to
acess it would be greatly appreciated. If this is not the best
newsgroup to post such quiestion I would also like to know which one I
should post to.

http://tahiti.oracle.com - contain the Oracle online Doc. set.
Check out the Delevopers Guide.

In Oracle term you need to use the Oracle Callable Interface (OCI).

Also http://asktom.oracle.com has many fine coding examples.


Reply With Quote
  #3  
Old   
amogh
 
Posts: n/a

Default Re: Accessing Oracle database on Solaris from C program - 02-22-2006 , 10:43 PM



agalkin (AT) audible (DOT) com wrote:
Quote:
I need to perform queries on Oracle database from C/C++ program on
Solaris. I have very extensive experience with C/C++ and MS Windows OS
but close to none with Solaris or Oracle. Our database adminstrator
told me that we do not have any documentation, he does not know if we
have any C libraries for accessing Oracle database. The only
information he provided me with is that we have Oracle version 9.2.0.7
(Oracle 9i) and Solaris 10. Any help with where to get Oracle C
libraries (header and lib files) and any sample source code how to
acess it would be greatly appreciated. If this is not the best
newsgroup to post such quiestion I would also like to know which one I
should post to.


Any help with where to get Oracle C
libraries (header and lib files)
OCI Libraries are installed with a client install. You can also install
and use Instant Client, which works without an Oracle Home.

Quote:
and any sample source code how to
acess it would be greatly appreciated.
The OCI documentation is here:
http://download-west.oracle.com/docs...b10779/toc.htm

You can find a few sample programs here:
http://www.oracle.com/technology/sam...oci/index.html


Rgds.
Amogh


Reply With Quote
  #4  
Old   
KM
 
Posts: n/a

Default Re: Accessing Oracle database on Solaris from C program - 02-23-2006 , 06:48 AM



If you are writing a C++ application, use OCCI which is the C++ interface.
http://www.oracle.com/technology/tec...cci/index.html
You have links to sample code, discussion forums and documentation from
the above site.
On Solaris, it is supported with SUN Workshop compiler.

You can download Instant Client which is a light weight installation:
http://www.oracle.com/technology/sof...ent/index.html

-krishna.


amogh wrote:

Quote:
agalkin (AT) audible (DOT) com wrote:

I need to perform queries on Oracle database from C/C++ program on
Solaris. I have very extensive experience with C/C++ and MS Windows OS
but close to none with Solaris or Oracle. Our database adminstrator
told me that we do not have any documentation, he does not know if we
have any C libraries for accessing Oracle database. The only
information he provided me with is that we have Oracle version 9.2.0.7
(Oracle 9i) and Solaris 10. Any help with where to get Oracle C
libraries (header and lib files) and any sample source code how to
acess it would be greatly appreciated. If this is not the best
newsgroup to post such quiestion I would also like to know which one I
should post to.


Any help with where to get Oracle C
libraries (header and lib files)

OCI Libraries are installed with a client install. You can also install
and use Instant Client, which works without an Oracle Home.

and any sample source code how to
acess it would be greatly appreciated.

The OCI documentation is here:
http://download-west.oracle.com/docs...b10779/toc.htm

You can find a few sample programs here:
http://www.oracle.com/technology/sam...oci/index.html


Rgds.
Amogh


Reply With Quote
  #5  
Old   
Martin Doherty
 
Posts: n/a

Default Re: Accessing Oracle database on Solaris from C program - 02-24-2006 , 11:56 AM



amogh wrote:

Quote:
agalkin (AT) audible (DOT) com wrote:

I need to perform queries on Oracle database from C/C++ program on
Solaris. I have very extensive experience with C/C++ and MS Windows OS
but close to none with Solaris or Oracle. Our database adminstrator
told me that we do not have any documentation, he does not know if we
have any C libraries for accessing Oracle database. The only
information he provided me with is that we have Oracle version 9.2.0.7
(Oracle 9i) and Solaris 10. Any help with where to get Oracle C
libraries (header and lib files) and any sample source code how to
acess it would be greatly appreciated. If this is not the best
newsgroup to post such quiestion I would also like to know which one I
should post to.


Any help with where to get Oracle C
libraries (header and lib files)

OCI Libraries are installed with a client install. You can also
install and use Instant Client, which works without an Oracle Home.

and any sample source code how to
acess it would be greatly appreciated.

The OCI documentation is here:
http://download-west.oracle.com/docs...b10779/toc.htm


You can find a few sample programs here:
http://www.oracle.com/technology/sam...oci/index.html


Rgds.
Amogh
What about Pro*C? The precompiler is also usable with C++ I think.

Martin


Reply With Quote
  #6  
Old   
Volker Hetzer
 
Posts: n/a

Default Re: Accessing Oracle database on Solaris from C program - 02-24-2006 , 11:58 AM



Martin Doherty schrieb:
Quote:
amogh wrote:

agalkin (AT) audible (DOT) com wrote:

I need to perform queries on Oracle database from C/C++ program on
Solaris. I have very extensive experience with C/C++ and MS Windows OS
but close to none with Solaris or Oracle. Our database adminstrator
told me that we do not have any documentation, he does not know if we
have any C libraries for accessing Oracle database. The only
information he provided me with is that we have Oracle version 9.2.0.7
(Oracle 9i) and Solaris 10. Any help with where to get Oracle C
libraries (header and lib files) and any sample source code how to
acess it would be greatly appreciated. If this is not the best
newsgroup to post such quiestion I would also like to know which one I
should post to.
Poor kid. Does it *have* to be C/C++? Can't you use Perl or Tcl/Tk?

Lots of Greetings!
Volker


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 - 2013, Jelsoft Enterprises Ltd.