Hi

Pro C Complier does not understand the analytical functions of oracle.

You should either create a view in oracle database and select from that view in your pro *C Code

or

You should construct the query as a string in pro C and then use
EXECUTE IMMEDIATE :query_str


regards
Hrishy