Re: Pro*C Problem

In article <bd4da684.0109130821.69c2e249_at_posting.google.com>, jblankenship_at_osc.uscg.mil says...
>
>I have an open TAR with Oracle about this. However, the TAR is 9 days
>old and they have not been able to help me resolve this. I am very
>frustrated right now.
>
>The servers that are currently in production are running Oracle 7.3.4
>in an HPUX 10.20 environment. We have bought new servers and have
>Oracle 8.1.6 installed on them in an HPUX 11.0 environment - 64 bit.
>So, we are recompiling all of the old code to run on the new servers.
>All of my code has compiled without errors, however, it does not run
>correctly.
>
>The code is a text-based menu. Users login to the Unix box via a
>telnet session and make their selection from the menu. All of the menu
>routines are select statements - no updating or deleting data from the
>database. However, I can not get the menu to connect to the database.
>It just hangs. No error message at all.
>
>I have combed MetaLink and Google trying all relevant suggestions I
>could find.
>
>** The $ORACLE_SID is lower case in all places: .profile, oratab,
>control files, initSID.ora, tnsnames.ora, listener.ora,
>** The $ORACLE_HOME is set correctly and is the absolute path.
>** Permissions for Oracle executable are 6755 and for tnslsnr are
>4755.
>** Umask is set to 022 for all database users.
>** The file system is not mounted with no set uid.
>** I can connect to the database via SQL*Plus with no problems.
>** I can issue a tnsping and receive data back.
>
>I can compile the Pro*C sample programs and they work just fine. I
>have actually copied the code from sample1.pc and pasted it into my
>code, in hopes of it working. No such luck. Since the code is
>identical, I would think it would have to be something outside of the
>code - the Makefile, for instance. The Oracle tech on my TAR doesn't
>think so. However, the Oracle sample code is compiled with the
>demo_proc.mk file. My code is compiled with a modified version of the
>Oracle Makefile.
>
>Is there anything that anyone can think of that maybe was deleted from
>the modified Makefile that needs to be added back in? Or is there
>something else all together that is missing? I am pulling my hair out!
>Any help is appreciated!
>

Have you compared the list of libraries and the explicit options passed to cc and ld between the sample and YOUR makefile? The issue undoubtably lies there.

Can you try using the demo_proc.mk makefile (see http://osi.oracle.com/~tkyte/proc_makefile/ for a pretty simple way to do that)

Short of that, perhaps you can post a cut and paste of the make of sample1.pc and a make of your program.

>Jennifer Blankenship
>jblankenship_at_osc(add dot)uscg(add dot)mil

--
Thomas Kyte (tkyte_at_us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
[Quoted] Opinions are mine and do not necessarily reflect those of Oracle Corp