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

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Sun, 27 Aug 2006 15:00:41 GMT
Message-ID: <Xns982C517FDD04SunnySD_at_70.168.83.30>


"CBro" <manohar.kaul_at_gmail.com> wrote in news:1156670849.703581.11810_at_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,
[Quoted] >>             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

>
>

http://tahiti.oracle.com holds the Oracle doc. set. Received on Sun Aug 27 2006 - 17:00:41 CEST

Original text of this message