Home » Developer & Programmer » Precompilers, OCI & OCCI » Oracle Database 18c XE and Pro*C (Unix (linux or AIX))
Oracle Database 18c XE and Pro*C [message #675919] Mon, 29 April 2019 09:44 Go to next message
mnardi
Messages: 6
Registered: April 2019
Junior Member
Hi,

could we use Pro*C with Oracle Database 18c XE ?

more precisely, I want to compile Pro*C on an AIX server and use Oracle Database 18c XE on a Linux server. Is it possible ?

if not, can I do this compilation if everything is on a linux server (BDD & ProC) ?

If ProC is not available with Oracle Database 18c XE, could I use the ProC of the enterprise version installed on an AIX server ?

thanks

Michel
Re: Oracle Database 18c XE and Pro*C [message #675921 is a reply to message #675919] Mon, 29 April 2019 11:30 Go to previous messageGo to next message
Michel Cadot
Messages: 66722
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You have to compile on the same OS than the one you will execute the generated binary.

Re: Oracle Database 18c XE and Pro*C [message #675980 is a reply to message #675921] Fri, 03 May 2019 03:44 Go to previous messageGo to next message
mnardi
Messages: 6
Registered: April 2019
Junior Member
Hi,

thanks,

And what about IBM AIX and ProC ?
Re: Oracle Database 18c XE and Pro*C [message #675983 is a reply to message #675919] Fri, 03 May 2019 07:59 Go to previous messageGo to next message
EdStevens
Messages: 1148
Registered: September 2013
Senior Member
I don't understand your concern.

Is it possible for an oracle client on AIX to access an Oracle database on Linux? Of course the answer is 'yes'.
Is there a Pro*C precompiler for AIX? Of course the answer is 'yes'.

So why do you think there might be an issue with the configuration you describe?
Re: Oracle Database 18c XE and Pro*C [message #675985 is a reply to message #675983] Fri, 03 May 2019 08:35 Go to previous messageGo to next message
mnardi
Messages: 6
Registered: April 2019
Junior Member
I want to use precompiler with ORACLE EXPRESS.
I know that's possible with Oracle enterprise, but with ORACLE XE...
Re: Oracle Database 18c XE and Pro*C [message #675987 is a reply to message #675985] Fri, 03 May 2019 09:10 Go to previous messageGo to next message
BlackSwan
Messages: 26643
Registered: January 2009
Location: SoCal
Senior Member
mnardi wrote on Fri, 03 May 2019 06:35
I want to use precompiler with ORACLE EXPRESS.
I know that's possible with Oracle enterprise, but with ORACLE XE...

Your original post in this thread was 4 days ago.
Please explain why between then & now you have not simply tested against an XE database to see the actual results for yourself.
Re: Oracle Database 18c XE and Pro*C [message #675988 is a reply to message #675987] Fri, 03 May 2019 09:31 Go to previous messageGo to next message
mnardi
Messages: 6
Registered: April 2019
Junior Member
because until now, I only find information that indicates that oracle 11 XE doesn't support precompiler C.
and I don't find any information about the precompiler with oracle 18XE...
Re: Oracle Database 18c XE and Pro*C [message #675989 is a reply to message #675988] Fri, 03 May 2019 09:48 Go to previous messageGo to next message
BlackSwan
Messages: 26643
Registered: January 2009
Location: SoCal
Senior Member
mnardi wrote on Fri, 03 May 2019 07:31
because until now, I only find information that indicates that oracle 11 XE doesn't support precompiler C.
and I don't find any information about the precompiler with oracle 18XE...

I am unclear what above means.
Show us using COPY & PASTE what happens when you try to compile & run Pro*C code against V11 XE.
I am unclear what problem needs to be solved.

I have no first hand knowledge of Pro*C, but I would believe that you can compile against EE & run against XE with no problem.
Re: Oracle Database 18c XE and Pro*C [message #675992 is a reply to message #675988] Fri, 03 May 2019 10:29 Go to previous messageGo to next message
Michel Cadot
Messages: 66722
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I don't know if Pro*C precompiler is in XE delivery but I'm sure it is in Client one.
If it is not in XE then install a client.

Just try "pcc" or "proc" at command line prompt.

Re: Oracle Database 18c XE and Pro*C [message #675993 is a reply to message #675989] Fri, 03 May 2019 10:31 Go to previous messageGo to next message
mnardi
Messages: 6
Registered: April 2019
Junior Member
I can't compile because :
https://docs.oracle.com/cd/E17781_01/license.112/e18068/toc.htm#XELIC116

...

2.1 Options and Major Features Not Included
The following options and major features are not included with Oracle Database XE:
• Development Platform
o Oracle Precompilers (Pro*C/C++, Pro*Cobol)
o SQLJ

...
Re: Oracle Database 18c XE and Pro*C [message #675994 is a reply to message #675993] Fri, 03 May 2019 11:06 Go to previous messageGo to next message
Michel Cadot
Messages: 66722
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Why do you refer to a 11g document for a 18c software?
You can get it from the Client delivery, however it is under the "Oracle Programmer" licensing:

Quote:
Oracle Programmer provides application programmers with a programmatic
interface to any edition of Oracle Database. However, in order to use Oracle
Programmer, you must purchase a separate Oracle Programmer license.
Oracle Programmer includes the following products:
• Embedded SQL-style interfaces: Pro*C/C++, Pro*COBOL, Pro*Fortran,
SQL*Module for Ada, SQLJ
• Utilities to generate host-language bindings from database schemas:
Object Type Translator and JPub
Re: Oracle Database 18c XE and Pro*C [message #676006 is a reply to message #675994] Mon, 06 May 2019 03:47 Go to previous message
mnardi
Messages: 6
Registered: April 2019
Junior Member
because I don't find the 18c document for ORACLE EXPRESS edition...

please could you give me the url of this document ?

thanks a lot

[Updated on: Mon, 06 May 2019 05:04]

Report message to a moderator

Previous Topic: SAVEPOINT in OCCI
Next Topic: sql_context
Goto Forum:
  


Current Time: Wed Dec 11 22:30:49 CST 2019