Re: Pro*C 2.03.0.0 hanging

In article <3ab6il$dqr_at_cronkite.Central.Sun.COM>, <mike_at_kcsun.central.sun.com> writes:
>
> I'm having a problem with a port from Oracle6 to 7.1.3.00- the Pro*C compiler
 hangs
> compiling modules that worked fine under 6. There is nothing apparently wrong
 with the environment (Solaris 2.3 is the OS)... has anyone else seen this?
>
> Thanks in advance, Mike
>
> ------------------------------------------------------------------
> Mike Summers mike_at_kcsun.central.sun.com
> Systems Engineer Phone: (913)451-6705
> Sun Microsystems Fax: (913)451-6946
>
>

The new Pro*C is basically an 'C' interpreter, while Pro*C 1.5 only tried to interpret the SQL specific statements. I have found a few places where it could not interpret legal 'C' statements. In one case, it hung (no error message, no timeout, nothing), when trying to use typedef'd pointers to structures (Oracle error # 245592).

The only way I was able to track it down was to remove all the new code, and add code back until it hung again. Only took 8 hours to find :( .

BTW, I also found that Pro*C 1.5 would compile PL*SQL code that had errors that were not found until running it through Pro*C 2.0. The main one was leaving off the colon on host variables. It compiled and ran fine with version 1.5, even though it was not correct syntax.

Hope this helps.

Keith

Keith Moore, P.E.                            Minerva Technology
keith_at_kmoore.itg.ti.com                      3102 Maple Ave, # 240
(214) 575-3460                               Dallas, Tx 75201
------------------------------------------------------------------