질문올리는데요.. toad에서는 select절의 select 절을 쓰면 먹는데요..
pc파일 을 컴파일하면 아래와 같은 오류가 나서요..
pcscfg.cfg 이걸 수정해줘야 하는게 있는지요? 이 안에는 ltype=short 이거 밖에 없어요...
System default option values taken from: /dbms_ns1/app/oracle/product/920/precomp/admin/pcscfg.cfg
Syntax error at line 391, column 28, file /nccr/dev/ccrGD/CGD08/src/csnt051sf.pc:
Error at line 391, column 28 in file /nccr/dev/ccrGD/CGD08/src/csnt051sf.pc
,(SELECT ORD_NO FROM TB_CORDORDINFO WHERE SA_ID = A.SA_ID and
rownum = 1) AA /*TEST */
...........................1
PCC-S-02201, Encountered the symbol "ORD_NO" when expecting one of the following
:
( ) * + - / . @ | at, day, hour, minute, month, second, year,
The symbol ")" was substituted for "ORD_NO" to continue.
Syntax error at line 391, column 91, file /nccr/dev/ccrGD/CGD08/src/csnt051sf.pc:
Error at line 391, column 91 in file /nccr/dev/ccrGD/CGD08/src/csnt051sf.pc
,(SELECT ORD_NO FROM TB_CORDORDINFO WHERE SA_ID = A.SA_ID and
rownum = 1) AA /*TEST */
................................................................................
..........1
PCC-S-02201, Encountered the symbol ")" when expecting one of the following:
; * + - / | for, union, at, connect, and, group, having,
intersect, minus, or, order, start, with, day, hour, minute,
month, second, year,
Syntax error at line 393, column 14, file /nccr/dev/ccrGD/CGD08/src/csnt051sf.pc:
Error at line 393, column 14 in file /nccr/dev/ccrGD/CGD08/src/csnt051sf.pc
FROM TB_CCPIENTUM A
.............1
PCC-S-02201, Encountered the symbol "FROM" when expecting one of the following:
; , = ( [ * ? | & < > + - / % . ^ *= /= %= += -= <<= >>= &&=
||= ^= | & == != <= >= << >> ++ -- ->
Syntax error at line 0, column 0, file /nccr/dev/ccrGD/CGD08/src/csnt051sf.pc:
Error at line 0, column 0 in file /nccr/dev/ccrGD/CGD08/src/csnt051sf.pc
PCC-S-02201, Encountered the symbol "<eof>" when expecting one of the following:
; : an identifier, end-exec, random_terminal
Error at line 0, column 0 in file /nccr/dev/ccrGD/CGD08/src/csnt051sf.pc
PCC-F-02102, Fatal error while doing C preprocessing
*** 오류 종료 코드 1
|