Problems with Pro*c in hp-ux 11.11 and Oracle 8.1.7 environment

[Salvador Solaz]

Hi,

We have an application in Pro*C that works correctly in a environment hp-ux 11.00 and Oracle 8.0.6. But we've problems with that application in hp-ux 11.11 and Oracle 8.1.7.

When we compile the source appears a warning that didn't appeare in the old version (hp-ux 11.00 and Oracle 8.0.6):

ld: Type mismatch for symbol "sqlca"; resolving NOTYPE symbol (in file /home/sgporta/provision/software/bin/temp/Gesbd.o) to NOTYPE symbol (in file /home/sgporta/provision/software/bin/temp/BddConexion.o)

1 warnings.


The application hangs when it read the first sentence /*EXEC SQL ... */

We think the problem can be done by the change of 32 to 64 bits compilation or link.

Could you help please? Thanks in advance for your help.

Salva.

[Yogeeraj_1]

Hi,

There might be a problem with the libraries with which your configuration file is linking.

I would test the demo first.

Normally, the makefile does it for you. You can also try just use the demo makefile
directly. To test out your pro*c install, you should build the demos anyway.
you would:

$ cd $ORACLE_HOME/precomp/demo/proc
$ make -f demo_proc.mk sample1

until that works -- you won't be precompiling anything. Once that works -- its
all downhill from there. test that out first. read the demo_proc.mk for more
insights.

Please find attached a few of my note that can help you troubleshoot this problem.

Best Regards
Yogeeraj