Home » Developer & Programmer » Precompilers, OCI & OCCI » Pro*C and 2 databases (oracle 12 / unix / C language)
Pro*C and 2 databases [message #681861] Fri, 04 September 2020 10:13 Go to next message
Messages: 1
Registered: September 2020
Junior Member

I write a program that needs to access at 2 databases in the same file toto.pc.

How do the pre-compiler know the 2 connections ?

Until now, I need 1 connection and I write in the makefile :

PROCPPFLAGS = define=__64BIT__ code=ANSI_C include=/usr/include include=... nls_local=yes varchar=yes
PROCPLSFLAGS	= sqlcheck=full userid=$(usercomp)/$(passwcomp)@${ORACLE_SID}
$(PROC) $(PROCPLSFLAGS) $(PROCPPFLAGS) iname=$* ireclen=132
Re: Pro*C and 2 databases [message #681863 is a reply to message #681861] Fri, 04 September 2020 10:40 Go to previous message
Michel Cadot
Messages: 67846
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

As far as I know, you cannot use multiple USERID option, so SQLCHECK=FULL is not possible if you have to check against 2 databases (or 2 users).

Previous Topic: error in C++ and occi call and Errors in OCCI header files.
Next Topic: OCI thread safe mode ?
Goto Forum:

Current Time: Tue May 11 06:38:57 CDT 2021