help for analysis function in PRO*C
652398Sep 24 2009 — edited Feb 25 2010In a PRO*C code, I wrote the following parts including an analysis function:
xec sql select a, b, max(c) over ( partition by a)
into ...
from t1
but it gave me the error when compiling:
Syntax error at line 63, column 35, file test.pc:
......
PCC-S-02201, Encountered the symbol "(" when expecting one of the following:
, into, from,
Error at line 0, column 0 in file SM_PageDel.pc
PCC-F-02102, Fatal error while doing C preprocessing
This SQL is all right when putting it into sqlplus. My question is : in PRO*C, it doesn't allow to use analysis function?
I'm very hurry for this question. Please help me if you know. Thanks in advanced!
My msn: bisal1130@yahoo.com.cn