OraFAQ Forum: Precompilers, OCI & OCCI » Oracle Database 18c XE and Pro*C

Home » Developer & Programmer » Precompilers, OCI & OCCI » Oracle Database 18c XE and Pro*C (Unix (linux or AIX))

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Database 18c XE and Pro*C [message #675919]

Mon, 29 April 2019 09:44

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

Report message to a moderator

Re: Oracle Database 18c XE and Pro*C [message #675921 is a reply to message #675919]

Mon, 29 April 2019 11:30

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Report message to a moderator

Re: Oracle Database 18c XE and Pro*C [message #675980 is a reply to message #675921]

Fri, 03 May 2019 03:44

mnardi
Messages: 6
Registered: April 2019

Junior Member

Hi,

thanks,

And what about IBM AIX and ProC ?

Report message to a moderator

Re: Oracle Database 18c XE and Pro*C [message #675983 is a reply to message #675919]

Fri, 03 May 2019 07:59

EdStevens
Messages: 1376
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?

Report message to a moderator

Re: Oracle Database 18c XE and Pro*C [message #675985 is a reply to message #675983]

Fri, 03 May 2019 08:35

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...

Report message to a moderator

Re: Oracle Database 18c XE and Pro*C [message #675987 is a reply to message #675985]

Fri, 03 May 2019 09:10

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: Oracle Database 18c XE and Pro*C [message #675988 is a reply to message #675987]

Fri, 03 May 2019 09:31

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...

Report message to a moderator

Re: Oracle Database 18c XE and Pro*C [message #675989 is a reply to message #675988]

Fri, 03 May 2019 09:48

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: Oracle Database 18c XE and Pro*C [message #675992 is a reply to message #675988]

Fri, 03 May 2019 10:29

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: Oracle Database 18c XE and Pro*C [message #675993 is a reply to message #675989]

Fri, 03 May 2019 10:31

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

...

Report message to a moderator

Re: Oracle Database 18c XE and Pro*C [message #675994 is a reply to message #675993]

Fri, 03 May 2019 11:06

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Oracle Database 18c XE and Pro*C [message #676006 is a reply to message #675994]

Mon, 06 May 2019 03:47

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 06:38:30 CST 2024