I am porting some pro*c code from Oracle8i to Oracle9i (from CODE=ANSI to CODE=CPP as well)

One thing that troubles me is that:

EXEC SQL AT :dbstring
select ......

would work under Oracle8i CODE=ANSI, but the same statement wouldn't work with Oracle9i CODE=CPP. Because I want to create 2 separate connection to different database within one program. so it's giving me some headache.

Does anyone has any suggestions?