Under Oracle8, using C to access the database, I can have something like the following
insert into XXX (col1)
values (decode(:jc,0,NULL,:jc ));
and bind the variable 'jc' once.
However, compiled under oracle7, when I run the program, it complains with 'Not all variables bound'. Seems the compiler sees two 'jc's in the building of the statement but only one bind command. One strategy may be to rename one of the variables and bind it as well, but this is very extensive throughout the program. Is there anyway to go around this?