| Author |
Message |
Ed Prochak
*nix forums Guru Wannabe
Joined: 17 Mar 2005
Posts: 271
|
 Posted: Tue Apr 12, 2005 2:31 pm Post subject:
Re: Common pro*c code for both Oracle and non-Oracle environments
|
|
|
I'm just curious, but what sort of business requirements cause you to
build code you will not use?
Ed |
|
| Back to top |
|
 |
Golan
*nix forums beginner
Joined: 05 Apr 2005
Posts: 9
|
| Posted: Thu Apr 07, 2005 2:45 am Post subject:
Re: Common pro*c code for both Oracle and non-Oracle environments
|
|
|
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 |
|
| Back to top |
|
|
Rauf Sarwar
*nix forums Guru
Joined: 03 May 2005
Posts: 353
|
| Posted: Wed Apr 06, 2005 3:35 pm Post subject:
Re: Common pro*c code for both Oracle and non-Oracle environments
|
|
|
Mark C. Stock wrote:
| Quote: | "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 |
|
| Back to top |
|
|
Mark C. Stock
*nix forums Guru
Joined: 05 May 2005
Posts: 730
|
| Posted: Wed Apr 06, 2005 10:13 am Post subject:
Re: Common pro*c code for both Oracle and non-Oracle environments
|
|
|
"Golan" <bcg008@mot.com> wrote in message
news:35e0ae97.0504052237.184b53ec@posting.google.com...
| Quote: | 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 |
|
| Back to top |
|
|
Golan
*nix forums beginner
Joined: 05 Apr 2005
Posts: 9
|
| Posted: Wed Apr 06, 2005 4:37 am Post subject:
Common pro*c code for both Oracle and non-Oracle environments
|
|
|
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 |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
Oracle
»
Tools
