Oracle database connectivity using C or C++

[Vasudevan MV]

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

[Sundar_7]

Are u looking PRO*C or something ?

[A. Clay Stephenson]

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.

[malay boy]

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

[Vasudevan MV]

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

[Indira Aramandla]

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

[Blueao]

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;
?