If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

SELECT
TO_CHAR(numcol)||charcol as newcol
FROM
TABLE
GROUP BY
TO_CHAR(numcol)||charcol
ORDER BY
newcol;

The statement returns the expected value (ex: 99999G) when run from the db.

We then embedded this statement into a C program, and though it compiled and ran, the results were bad (-412628).

Someone suggested that our C preprocessor -- the thing that translates the SQL into the appropriate C code -- was older than the Oracle version we are using, and the solution was to rewrite the SQL so that the preprocessor could handle it. The DBAs were not able to help, and suggested that we turn to someone who knows Pro*C.

Does anyone here have a clue? Any help would be greatly appreciated. Thanks!