pro c precompiler problems

From: <tracey5274_at_my-dejanews.com>
Date: Tue, 15 Sep 1998 08:31:05 GMT
Message-ID: <6tl8k9$acn$1@nnrp1.dejanews.com>

migrating from version 7.1.6 to version 7.3.4 of oracle

I have some embedded SQL in c of the following form

Select *
from TABLE
Where column1 = :param1
Order By INSTR(column2,:param2) DESC,

INSTR(column2,:param3) DESC,

This works fine on 7.1.6 but the precompiler for 7.3.4 seem to ignore the Order By clause. The actual select is exceedingly long and so its difficult to see the entire compiled statement in sq0001 etc

Any theories????

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Sep 15 1998 - 03:31:05 CDT