Pro*C v1.5 to V2.0 problems...send help
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