Re: Embedded SQL compiler at Linux

The following trick worked for me.

[Quoted] Open the pcscfg.cfg file in $ORACLE_HOME/precomp/admin folder and add the following settings. After this, it should work.

---
sys_include=(/usr/include, /usr/include/sys,
/usr/lib/gcc-lib/i386-glibc21-linux/egcs-2.91.66/include)
include=(/opt/oracle/product/8.1.7/precomp/public)
include=(/opt/oracle/product/8.1.7/rdbms/public)
include=(/opt/oracle/product/8.1.7/rdbms/demo)
---

BTW, we are using Oracle 8.1.7 on RedHat Linux 7.2
It could be different on your version.

HTH

- MC

"Ole Streicher" <ole-usenet-04_at_gmx.net> wrote in message
news:qfg00uetk1.fsf_at_ebp00439.ebp.de...


> Hello Group!


>

> I've got some embedded sql sources which I shall translate with the

> precompiler "proc". Unfortunately, it doesn't work for me:

>

> -------------------------8<--------------------------------------------

> > proc mysql.pc

> Pro*C/C++: Release 8.1.7.0.0 - Production on Tue May 14 15:19:28 2002

>

> (c) Copyright 2000 Oracle Corporation.  All rights reserved.

>

> System default option values taken from:

/opt/oracle/OraHome/precomp/admin/pcscf


> Error at line 34, column 11 in file /usr/include/stdio.h


> # include <stddef.h>

> ..........1

> PCC-S-02015, unable to open include file

> [...]

> -------------------------8<--------------------------------------------

>

> This looks if the precompiler would not find some standard header

> files. I then tried to pass the header paths as command line option

> also fails:

>

> -------------------------8<--------------------------------------------

> > proc INCLUDE=/usr/lib/gcc-lib/i486-suse-linux/2.95.2/include \

>   INCLUDE=/opt/oracle/product/8.1.6/rdbms/demo mysql.pc

> [...]

> Syntax error at line 117, column 2, file

/usr/lib/gcc-lib/i486-suse-linux/2.95.2Error at line 117, column 2 in file
/usr/lib/gcc-lib/i486-suse-linux/2.95.2/include/limits.h


> #include_next <limits.h>                /* recurse down to the real one */


> .1

> PCC-S-02014, Encountered the symbol "include_next" when expecting one of

the following:


>

>    a numeric constant, newline, define, elif, else, endif,


>    error, if, ifdef, ifndef, include, line, pragma, undef,

>    an immediate preprocessor command, a C token,

> The symbol "newline," was substituted for "include_next" to continue.

> -------------------------8<--------------------------------------------

>

> This looks now really funny to me.

>

> So, I have now a couple of questions:

> - This is my first use of "proc", is there anything which I did wrong?

>   Maybe, the precompiler isn't installed correctly? How do I test that?

> - How cat I force "proc" to compile successfully files on Linux (gcc)?

> - Is the use of files from the "demo" dir usual in oracle (the source

>   uses the file "oratypes.h")? Do I then really need to specify the

>   directory?

> - How can I call "proc" system independent? I want to include the

>   sources in a package that shall be build with "autoconf/automake".

>

> I am using Oracle 8.1.6 and 8.1.7 and SuSE Linux 7.0 and 7.3.

>

> Any suggestions?

>

> Ole

>