Programming

Hi all,

I have created a post-C (PC) script OrdItmpopulate.pc. When I am compiling this using the “Make” command I am getting the following error. My “make” command looks like this:



make -f $ORACLE_HOME/precomp/demo/proc/demo_proc.mk build EXE=OrdItmpopulate8.exe OBJS="OrdItmpopulate8.o" exfcns.c PROCFLAGS="MODE=ANSI" CC="c89" CFLAGS="shell_flags_compiler_hp"



“msg_open” is a function declared in exfcns.c which is #included in my PC script.

The .o file is getting created and the exe file is also getting created but it is not executing.



The compile time error is:



c89 -o OrdItmpopulate8.exe OrdItmpopulate8.o -L/u01/app/oracle/dev/produ

ct/8.1.7/lib/ -lclntsh `cat /u01/app/oracle/dev/product/8.1.7/lib/sysliblist`

-lm -lpthread -lpthread

/usr/ccs/bin/ld: Unsatisfied symbols:

msg_open (first referenced in OrdItmpopulate8.o) (code)

ex_is_spaces (first referenced in OrdItmpopulate8.o) (code)

ex_set_ifile_decimal_from_part (first referenced in OrdItmpopulate8.o) (code)

ex_set_decimal_part_from_part (first referenced in OrdItmpopulate8.o) (code)

ex_string_part_value (first referenced in OrdItmpopulate8.o) (code)

program_return_code (first referenced in OrdItmpopulate8.o) (data)

terminating_flag (first referenced in OrdItmpopulate8.o) (data)

ex_operators (first referenced in OrdItmpopulate8.o) (code)

ex_set_generic_char_from_part (first referenced in OrdItmpopulate8.o) (code)

ex_set_part_from_ifile (first referenced in OrdItmpopulate8.o) (code)

ex_arithmetic (first referenced in OrdItmpopulate8.o) (code)

ex_keyword (first referenced in OrdItmpopulate8.o) (code)

ex_set_varstr_part_from_part (first referenced in OrdItmpopulate8.o) (code)

ex_set_ifile_integer_from_part (first referenced in OrdItmpopulate8.o) (code)

ex_init_chbuf (first referenced in OrdItmpopulate8.o) (code)

ex_set_part_from_long (first referenced in OrdItmpopulate8.o) (code)

ex_reuse_chbuf (first referenced in OrdItmpopulate8.o) (code)

ex_set_integer_part_from_part (first referenced in OrdItmpopulate8.o) (code)

ex_keyword_zero_num (first referenced in OrdItmpopulate8.o) (data)

msg_write_msg (first referenced in OrdItmpopulate8.o) (code)

msg_terminate (first referenced in OrdItmpopulate8.o) (code)

ex_keyword_space (first referenced in OrdItmpopulate8.o) (data)

*** Error exit code 1



Stop.



Please help me in this as soon as possible.

It's not a Pro*C problem. It's a linking problem. Since you are dealing with a lot of variables: complex make file, multiple source files, precompilers, etc - there are too many things to rule out for us to get a good solution

So, I'll make a simple suggestion that may not be the best solution but has the highest probability of working:

Somewhere near the top of your OrdItmpopulate.pc file (before you invoke "msg_open" or any of the other calls that are causing errors) put the following:

Code:

EXEC SQL INCLUDE exfcns.c;

NOTE: exfcns.c has to exist either in the current directory or in one of the directories specified to the proc (pro*C precompiler) command. The directories specified with -I
I would place exfcns.c in the current directory and add

Code:

 -I.

as another proc command line parameter.