Home » Developer & Programmer » Precompilers, OCI & OCCI » Can a Pro*c program run without an oracle client installed on the machine ?
icon5.gif  Can a Pro*c program run without an oracle client installed on the machine ? [message #162072] Wed, 08 March 2006 09:59 Go to next message
sgobin
Messages: 3
Registered: March 2006
Location: France
Junior Member

I would like to create a C program using pro*c that would run on a machine without the oracle client software installed.

Is it possible ?

How can i do this ? Is there a way not using the dynamic libraries but instead include them in the program at compile time in a static way ?

Thanks for your responses,

Stephane.
Re: Can a Pro*c program run without an oracle client installed on the machine ? [message #162078 is a reply to message #162072] Wed, 08 March 2006 10:13 Go to previous messageGo to next message
aciolac
Messages: 242
Registered: February 2006
Senior Member
No, Pro*C cannot run without Oracle Client because it is a part of Oracle Client. You cannot work by Oracle Database without Oracle Client installed on the client machine.
Re: Can a Pro*c program run without an oracle client installed on the machine ? [message #162079 is a reply to message #162078] Wed, 08 March 2006 10:39 Go to previous messageGo to next message
sgobin
Messages: 3
Registered: March 2006
Location: France
Junior Member
Thank you for your response.
But, it's not really Pro*c that i want to run on a machine with no oracle client software installed, but a program compiled on a machine with the pro*c tool that is to be used on a machine with no oracle client.
I've done a program using pro*c that work on the machine i used in development, but that not work on the production machine. So i was wondering if there was a way to include the libraries in a static manner at compile time so that you don't have to install oracle client software.
Re: Can a Pro*c program run without an oracle client installed on the machine ? [message #162081 is a reply to message #162072] Wed, 08 March 2006 10:54 Go to previous messageGo to next message
aciolac
Messages: 242
Registered: February 2006
Senior Member
I am also repeat - YOU CANNOT TO WORK WITH ORACLE DATABASE WITHOUT ORACLE CLIENT INSTALLED. There no importance if Your program are use PRO*C or not - without Oracle client impossible to work with database.
Re: Can a Pro*c program run without an oracle client installed on the machine ? [message #162284 is a reply to message #162081] Thu, 09 March 2006 09:44 Go to previous message
sgobin
Messages: 3
Registered: March 2006
Location: France
Junior Member
Although, it's seems possible, you need to do this (Linux system) :
$ORACLE_HOME/bin/genclntst to generate the static library libclntst10.a which is not built in the default distribution
and in the makefile, replace LLIBCLNTSH by LLIBCLNTST :
For my program :
$(CC) -g -o $(@) $^ -L$(LIBHOME) $(LLIBCLNTST) $(STATICPROLDLIBS) -L$(REPCOM) -lc -lform -lncurses


But, i run into another error :

gcc -g -o wecind wecindDATA.o wecindIHM.o alertes.o weatrm.o cgachgIHM.o cgachgDATA.o egamasDATA.o egamasIHM.o wenpce.o wesptquaiihm.o wetptquaidata.o wejsit.o wejsitIHM.o hebpho.o weppri.o ./commun/gestionRejet.o ./commun/structures.o ./commun/weftrac.o ./commun/weguti.o ./commun/wezbase.o welmul.o cgutra.o cgutraIHM.o ./commun/gestionnaireTractions.o ecran.o gestionClients.o ecranListe.o ./commun/parametres.o ./commun/webdat.o ./commun/wedsal.o ./commun/lectureColis.o ./commun/gestionCodeBarre.o ./commun/emetteurDonnees.o ./commun/weocom.o weupoidsDATA.o weupoidsIHM.o wehracDATA.o wehracIHM.o ./commun/majBDPecDirect.o ./commun/majBDChgtDirect.o -L/opt/oracle10g/10.1.0//lib/ -lclntst10 /opt/oracle10g/10.1.0//lib/scorept.o /opt/oracle10g/10.1.0//lib/sscoreed.o /opt/oracle10g/10.1.0//rdbms/lib/kpudfo.o -lclient10 -lsql10 `cat /opt/oracle10g/10.1.0//lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lnro10 `cat /opt/oracle10g/10.1.0//lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lclient10 -lnnetd10 -lvsn10 -lcommon10 -lgeneric10 -lmm -lcore10 -lxml10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 `cat /opt/oracle10g/10.1.0//lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lnro10 `cat /opt/oracle10g/10.1.0//lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lclient10 -lnnetd10 -lvsn10 -lcommon10 -lgeneric10 -lpls10 -lcore10 -lxml10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 -lclient10 -lnnetd10 -lvsn10 -lcommon10 -lgeneric10 -lcore10 -lxml10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 `cat /opt/oracle10g/10.1.0//lib/sysliblist` -ldl -lm -L./commun/ -lc -lform -lncurses
/opt/oracle10g/10.1.0//rdbms/lib/kpudfo.o(.text+0x0): In function `kpugml':
: définitions multiples de « kpugml »
/opt/oracle10g/10.1.0//lib//libclntst10.a(kpudfo.o)(.text+0x0): défini pour la première fois ici
/opt/oracle10g/10.1.0//rdbms/lib/kpudfo.o(.text+0xc): In function `kpuicx':
...

Does anybody have an idea where the error comes from ?

Thanks in advance,

Stephane.





Previous Topic: pro c
Next Topic: Environment::createEnvironment() & Unicode support
Goto Forum:
  


Current Time: Sun Dec 22 00:58:30 CST 2024