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
zephyrin
Messages: 1
Registered: September 2020
Junior Member
Hi,

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 :

PROC		= proc THREADS=YES
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
Thanks
Michel
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: 68625
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: Thu Mar 28 17:58:06 CDT 2024