Problem: Forms 3.0 migration from Oracle 7.1.4.1 to Oracle 7.2.3 on HP-UX10.2

From: Gord Harris <gordon_harris_at_northwood.ca>
Date: 1998/03/05
Message-ID: <6dn4ve$coh$1@news.bctel.net>#1/1

We recently upgraded our database from Oracle 7.1.4.1 to Oracle 7.2.3. The Oracle forms application that runs against this database calls user exits, which must be compiled into sqlforms30x. It appears Oracle changed the names of the FORMS library files used to generate sqlforms30 and sqlforms30x, necessitating an update to the Makefile used to compile the executable.

I found a makefile in /opt/oracle/v7.2.3.0.0/forms30/lib called sqlforms30.mk which I modified to include the user exits that are compiled into the executable.

However, when I try to compile the sqlforms30x executable I get the following error:

> make -f sqlforms30.mk sqlforms30x
cc -Wl,-aarchive -L/opt/oracle/v7.2.3.0.0/lib -o sqlforms30x
/opt/oracle/v7.2.3.

0.0/forms30/lib/iaddrvc.o iaxpcc.o iapxtb.o vdd.o cmdlin.o ctick.o cycpx.o cycrx
.o del1x.o del2x.o del3x.o del4x.o glfe.o invdx.o invsx.o paintu.o pushx.o scatx
.o sclsx.o stkrx.o strax.o trfr.o trftkx.o resv.o wrsrx.o wsx.o ksilib.o
/opt/or

acle/v7.2.3.0.0/forms30/lib/ifmdmf.o
/opt/oracle/v7.2.3.0.0/forms30/lib/ifplut.o
 /opt/oracle/v7.2.3.0.0/lib/libforms30c.a
/opt/oracle/v7.2.3.0.0/lib/libforms30.

a /opt/oracle/v7.2.3.0.0/lib/libforms30p.a


/opt/oracle/v7.2.3.0.0/lib/liboktc.a

/opt/oracle/v7.2.3.0.0/lib/libokt.a

/opt/oracle/v7.2.3.0.0/forms30/lib/libpls.a

/opt/oracle/v7.2.3.0.0/lib/libforms30c.a
/opt/oracle/v7.2.3.0.0/lib/libforms30.a

 -lsql -locic
/opt/oracle/v7.2.3.0.0/lib/osntab.o -lsqlnet -lora -lsqlnet -lora
-lnlsrtl3 -lnlsrtl -lc3v6 -lcore3 -lcore -lnlsrtl3 -lnlsrtl -lcore3 -lcore - lcl
-lm /trans/dvlp/lib/stringlib.a /trans/dvlp/lib/stringlib.a -lcl -lm
/trans/dvlp
/lib/stringlib.a
/usr/ccs/bin/ld: Unsatisfied symbols:

   shl_findsym (code)
   shl_load (code)
*** Error exit code 1

When I try to compile sqlforms30 (without the exits), I get the same error. From what I gather, this error refers to a shared library.

Has anyone else encountered this problem on an HP-UX 10.2 system? If so, could you please get back to me with your solution.

Gord Harris Received on Thu Mar 05 1998 - 00:00:00 CST