Common pro*c code for both Oracle and non-Oracle environments

[Golan]

Hi,
I have a PRO*C code that may run also on PCs where Oracle is not
installed. In this case ofcourse the code that read & write from the
database should be ignored.
What should I specify in the code so the oricedures with the database
access will be ignored in case Oracle is not installed?

Thanks

[Mark C. Stock]

"Golan" <bcg008@mot.com> wrote in message
news:35e0ae97.0504052237.184b53ec@posting.google.com... Hi, I have a PRO*C code that may run also on PCs where Oracle is not installed. In this case ofcourse the code that read & write from the database should be ignored. What should I specify in the code so the oricedures with the database access will be ignored in case Oracle is not installed? Thanks

your initial attempt to connect to the database will fail -- just record
that fact in the variable of your choice, and check that variable in your
code before attempting any database access

++ mcs

[Rauf Sarwar]

Mark C. Stock wrote: "Golan" <bcg008@mot.com> wrote in message news:35e0ae97.0504052237.184b53ec@posting.google.com... Hi, I have a PRO*C code that may run also on PCs where Oracle is not installed. In this case ofcourse the code that read & write from
the database should be ignored. What should I specify in the code so the oricedures with the
database access will be ignored in case Oracle is not installed? Thanks your initial attempt to connect to the database will fail -- just
record that fact in the variable of your choice, and check that variable in
your code before attempting any database access ++ mcs

Doesn't Pro*C require Oracle client to be installed for remote
connections (atleast middleware SQL*Net/Net8/Net9 etc at minimum)?. If
so, then how could he launch the process without required Oracle client
dll's installed before even attempting a connection?

Regards
/Rauf

[Golan]

Well the pro*c does required an Oracle clinet installation, but we
intend to compile the code on a client which has this installation,
but to run it not necessarily on the same client.
Regarding checking DB connection, I'll adapt this idea.

Thanks

[Ed prochak]

I'm just curious, but what sort of business requirements cause you to
build code you will not use?

Ed