Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Trying to compile a ProC in Oracle 10g R1

Re: Trying to compile a ProC in Oracle 10g R1

From: CBro <manohar.kaul_at_gmail.com>
Date: 27 Aug 2006 02:27:29 -0700
Message-ID: <1156670849.703581.11810@74g2000cwt.googlegroups.com>


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'
flatten.o(.text+0x3dc): In function `process_1': : undefined reference to `sqlcxt'
flatten.o(.text+0x3fc): In function `process_1': : undefined reference to `sqlald'
flatten.o(.text+0x57d): In function `process_1': : undefined reference to `sqlcxt'
flatten.o(.text+0x5c9): In function `process_1': : undefined reference to `sqlclu'
flatten.o(.text+0x5db): In function `process_1': : undefined reference to `sqlald'
flatten.o(.text+0x754): In function `process_1': : undefined reference to `sqlcxt'
flatten.o(.text+0x7e9): In function `process_1': : undefined reference to `sqlnul'
flatten.o(.text+0xa1a): In function `process_1': : undefined reference to `sqlcxt'
flatten.o(.text+0xbc4): In function `process_2': : undefined reference to `sqlcxt'
flatten.o(.text+0xcf8): In function `process_2': : undefined reference to `sqlclu'
flatten.o(.text+0xd76): In function `process_2': : undefined reference to `sqlcxt'
flatten.o(.text+0xe02): In function `process_2': : undefined reference to `sqlcxt'
flatten.o(.text+0x100e): In function `main': : undefined reference to `sqlcxt'
flatten.o(.text+0x10c1): In function `main': : undefined reference to `sqlcxt'
flatten.o(.text+0x1193): In function `main': : undefined reference to `sqlcxt'
collect2: ld returned 1 exit status
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 - 04:27:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US