Re: Oracle, PL/SQL to Visual C++ ?

Sure!

All you have to do is to get your hands on a version of Pro*C. Which version depends on your database and VC++ versions. Basically Pro*C is a pre-compiler which interprets a specific set of Oracle SQL statements written in your c/c++ source. This approach use native sql*net whithout any layers (i.e. ODBC).

The alternative to Pro*C is Oracle OCI (Oracle Call Interface) which is a set of C functions through which you access your database. Though being a lot more complicated, by using OCI you are producing "true" c programs

Best regards.

Emil Hahn Pedersen

Andy Hardy <aph_at_ahardy.demon.co.uk> wrote in article <0YN5yCAYqojzEwro_at_ahardy.demon.co.uk>...
> Hi,
>
> Is it possible to get Visual C++ to talk to Oracle PL/SQL procedures?
>
> I know that VC++ can use ODBC to access Oracle as a standard datasource
> (if I ever get ODBC to work on our NT systems...) but is there a way of
> accessing the stored procedures?
>
> Also, is there a tool out there which will allow VC++ to use SQL*NET
> connections? Some form of pro*C compiler for VC++, perhaps?
>
> In essence, I don't want to lose the power of the Oracle environment
> just because we want to use VC++ for some pretty front ends.
>
> Thoughts?
>
> Andy
>
> Andy Hardy. PGP key available on request
> ===============================================================
>
Received on Tue Jun 03 1997 - 00:00:00 CDT