Re: Trying to compile a ProC in Oracle 10g R1
Date: 27 Aug 2006 02:27:29 -0700
Message-ID: <1156670849.703581.11810_at_74g2000cwt.googlegroups.com>
[Quoted] Just a quick snapshot of what I tried to run my ProC program, so you
know what I am talking about.
Thanks in advance!
[oracle_at_dev flatfile]$ ls -altr
total 32
-rw-r--r-- 1 oracle oinstall 1107 May 14 2002 unloader.tar.gz drwxr-xr-x 2 oracle oinstall 4096 Aug 27 15:50 unloader -rw-r--r-- 1 oracle oinstall 5782 Aug 27 15:55 flatten.pc -rw-r--r-- 1 oracle oinstall 329 Aug 27 16:21 Makefile drwx------ 16 oracle oinstall 4096 Aug 27 18:51 .. -rw-r--r-- 1 oracle oinstall 2658 Aug 27 19:24 proc.mk drwxr-xr-x 3 oracle oinstall 4096 Aug 27 19:25 .
[oracle_at_dev flatfile]$ proc flatten
Pro*C/C++: Release 10.1.0.3.0 - Production on Sun Aug 27 19:25:32 2006
Copyright (c) 1982, 2004, Oracle. All rights reserved.
System default option values taken from: /usr/local/u01/app/oracle/product/10.1.0/db_1/precomp/admin/pcscfg.cfg
[oracle_at_dev flatfile]$ make -f ./proc.mk flatten gcc -c -I.
-I/usr/local/u01/app/oracle/product/10.1.0/db_1/precomp/public -I/usr/local/u01/app/oracle/product/10.1.0/db_1/rdbms/public flatten.c gcc -L/usr/local/u01/app/oracle/product/10.1.0/db_1/lib/ flatten.o`cat /usr/local/u01/app/oracle/product/10.1.0/db_1/lib/sysliblist` -ldl -lm -o flatten
flatten.o(.text+0x233): In function `sqlerror_hard': : undefined reference to `sqlcxt'
[Quoted] flatten.o(.text+0x3dc): In function `process_1': : undefined reference to `sqlcxt'
[Quoted] flatten.o(.text+0x3fc): In function `process_1': : undefined reference to `sqlald'
[Quoted] flatten.o(.text+0x57d): In function `process_1': : undefined reference to `sqlcxt'
[Quoted] flatten.o(.text+0x5c9): In function `process_1': : undefined reference to `sqlclu'
[Quoted] flatten.o(.text+0x5db): In function `process_1': : undefined reference to `sqlald'
[Quoted] flatten.o(.text+0x754): In function `process_1': : undefined reference to `sqlcxt'
[Quoted] flatten.o(.text+0x7e9): In function `process_1': : undefined reference to `sqlnul'
[Quoted] flatten.o(.text+0xa1a): In function `process_1': : undefined reference to `sqlcxt'
[Quoted] flatten.o(.text+0xbc4): In function `process_2': : undefined reference to `sqlcxt'
[Quoted] flatten.o(.text+0xcf8): In function `process_2': : undefined reference to `sqlclu'
[Quoted] flatten.o(.text+0xd76): In function `process_2': : undefined reference to `sqlcxt'
[Quoted] flatten.o(.text+0xe02): In function `process_2': : undefined reference to `sqlcxt'
[Quoted] flatten.o(.text+0x100e): In function `main': : undefined reference to `sqlcxt'
[Quoted] flatten.o(.text+0x10c1): In function `main': : undefined reference to `sqlcxt'
[Quoted] flatten.o(.text+0x1193): In function `main': : undefined reference to `sqlcxt'
collect2: ld returned 1 exit status
[Quoted] make: *** [flatten] Error 1
CBro wrote:
> Hi guys,
> I just recently installed Oracle 10g R1 on my Fedora Core 2
> server. I have come across the need to run a ProC from askTom that
> allows me to dump the data in Oracle tables to a CSV file! This is
> absolutely essential and from the reviews on AskTom I believe this
> script is currently the fastest way of doing so at the moment.
>
> Now I am not sure as to whether Oracle 10g R1.0.3 comes shipped with
> the ProC compiler. So I went ahead and downloaded the instantclient
> 10.1 SDK which I read allows you to run ProC programs. I can get to the
> stage where I can run the "proc" command with a .pc file argument.
> Just dont know what to do next. As when I compile the .c file it
> generates I get a whole bunch of errors!
>
> Is there a manual or a guide that shows you how to get ProC working on
> Oracle 10g R1 so I can start to compile ProC programs?
>
> Cheers,
> MK
Received on Sun Aug 27 2006 - 11:27:29 CEST