topic Re: Oracle database connectivity using C or C++ in Operating System - HP-UX

Oracle database connectivity using C or C++

Vasudevan MV — Thu, 17 Jun 2004 09:47:00 GMT

Hi,

Can anyone tell me, how can I connect oracle database using C or C++ on HP-UNIX?. Is there any reference document or link? .

Thanks in advance.
Regards,
Vasu

Re: Oracle database connectivity using C or C++

Sundar_7 — Thu, 17 Jun 2004 19:15:24 GMT

Are u looking PRO*C or something ?

Re: Oracle database connectivity using C or C++

A. Clay Stephenson — Thu, 17 Jun 2004 20:29:50 GMT

While at a very limited level you could use popen() or system() to execute a sql script and capture the output, the real method is to use Oracle's ProC that will allow you to embed SQL statements inside your C or C++ code.

Re: Oracle database connectivity using C or C++

malay boy — Thu, 17 Jun 2004 21:25:10 GMT

Agreed we used ProC here to build our application and connect to oracle database.

Re: Oracle database connectivity using C or C++

Vasudevan MV — Thu, 17 Jun 2004 23:55:00 GMT

Thanks for your replies.

I am not looking for pro C, looking for some kind of library through which we can connect to oracle database using C or C++.

Note: I had posted this question yesterday night, so I could not assign the points. Is there any otherway to assign the points?

Regards,
Vasu

Re: Oracle database connectivity using C or C++

Indira Aramandla — Fri, 18 Jun 2004 00:36:11 GMT

Hi Vasu,

Pro*C/C++, precompilers connect to oracle database using embedded sql statement connect.

Example:-

EXEC SQL CONNECT :uid IDENTIFIED BY :pwd;

SQLLDAGetCurrent(&lda);

EXEC SQL EXECUTE
BEGIN
------ END;
END-EXEC;

Oracle supports
Â· C, by means of the Oracle Call Interface (OCI), as described in the Oracle Call Interface Programmer's Guide

Â· C++, by means of the Pro*C/C++ precompiler, as described in the Pro*C/C++ Precompiler Programmer's Guide.

Demo programs are located in
$ORACLE_HOME/precomp/demo/proc directory.

I hope this helps

Indira

Re: Oracle database connectivity using C or C++

Blueao — Fri, 12 Jan 2007 19:45:16 GMT

If I want to connect to the Oracle Database which is installed in different host, how can I
write this sentence:
EXEC SQL CONNECT :uid IDENTIFIED BY :pwd;
?