Pro*C v1.5 to V2.0 problems...send help

From: Dandret1 <dandret1_at_aol.com>
Date: 1995/05/03
Message-ID: <3o9e10$1a9_at_newsbf02.news.aol.com>#1/1


Our application must move from V7.0.16 of Oracle to v7.1.4 or higher of oracle.
The higher version contains a fix that prevents a locking problem (that has
brought this critical application to a halt). In all our urgency to move, we wanted to wait until a crucial Pro*C program is
recompiled under V2.0. We know it will run sucessfully compiled under v1.6,
but my boss is afraid that future versions of oracle won't have v1.6.   After this scenario, when recompiling, the compiler said that I must pass
varchars by pointer and NOT by value. Well, after making that change, the compiler is not liking one particular subroutine. It's not complaining about what
I changed, but rather, an EXEC SQL call that it makes.   The error reads as follows:
EXEC SQL select nvl(arf,),
PGELOG: fatal error
wrong number or types of arguments in call to '<=' EXEC SQL select nvl(arf,0),
PCC-s-02000
Semantic error.    

  arf is a column of the table, I can perform the sql call under sqlplus without
error, also, other subroutines in the program due similar calls, and were not
flagged by the precompiler.
  From other messages on this news.group, I get a feeling that v2.0 is way buggy.
  Can anybody give me some feedback on this?? Should I convince management to stick with v1.6 of Pro*c in this hopes that v2.0 with be patched up??

Thanks

Tom D'Andrea
285 E. Dominion Blvd
Columbus, Ohio 43214 Received on Wed May 03 1995 - 00:00:00 CEST

Original text of this message