Re: PRO*C question

In article <3197m4$ebb_at_dcsun4.us.oracle.com>, surman_at_wwsun10.us.oracle.com (Scott Urman) wrote:

> In article <318rq8$bi3_at_apakabar.cc.columbia.edu>, sb63_at_namaste.cc.columbia.edu (Semyon Basin) writes:
> |>
> |> Hi, Everyone!
> |> I'm just started to full around with oracle so excuse me for a newbie question.
> |> How do i link a program after using PRO*C.
> |> Please do not tell me to GET manual and READ it.
> |> The only thing which is in a manual is an example of the "make" file:
> |> oracle.mk
> |> I was trying to use that file without any luck.
> |>
> |> cc -L/${ORACLE_HOME}/lib -s -o test test.o ${ORACLE_HOME}/lib/libocic.a
> |> ${ORACLE_HOME}/lib/osntab.o -lsqlnet -lora -lsqlnet -lora -lnlsrtl -lcv6
> |> -lcore -lnlsrtl -lcv6 -lcore -lm -lcore -lm
> |>
> |> The output is:
> |>
> |> ld:
> |> Undefined:
> |> sqlcex
> |>
> |> If any kind soul have an idea - please help me.
> |> George.
>
> You should use proc.mk, not oracle.mk. Try 'make -f proc.mk program', where your
> file is in program.pc. Don't put the .pc extension. proc.mk can be found in
> $ORACLE_HOME/proc/demo. sqlcex() is actually defined in libsql.a, found in
> $ORACLE_HOME/lib under Oracle7, and $ORACLE_HOME/rdbms/lib under version 6.

And if you're in a c-shell environment, it wont work as expected as there is a built-in procedure "test" which will win if you type 'test'.

-- 
Leo Mannhart
Planning Office
University of Zurich               phone: ++41 1 257 23 34
Kuenstlergasse 15                    fax: ++41 1 257 22 12
CH-8001 Zurich, Switzerland        eMail: mannhart_at_zuv.unizh.ch