toad에서 실행 하면 잘되는데..
proc에서 할려면 이렇게 오류가 나네여..
고수님들의 많은 도움 부탁합니다.
원래 쿼리문
SELECT
JB_BLOCKNUM, JB_NAP_TOTAMT, JB_GuID,
LPAD(JB_Sido, 2,'0') || LPAD(JB_GuID, 3,'0') || LPAD(BR_Bigo, 3, '0') ||
LPAD(JB_IlgyeBRCode, 6, '0') || LPAD(JB_SunapDate, 8, '0') ||
(SELECT HD_Date FROM TB_HolidayInfo
WHERE HD_Date >= :szSunap
AND HD_Gubun = '0'
AND ROWNUM <= 1 ) || jb_ichedate || jb_napgigubun || LPAD(JB_Nap_TotAmt, 11, '0') || JB_Sido || JB_GuID || JB_Check1 || JB_Semok1 || JB_Semok2 ||
JB_Semok3 || JB_BugwaYYYYMM || JB_GiGubun || JB_DongID || JB_GwaseNum || JB_Check2 ||
LPAD(JB_NapNaeAmt, 11, '0') ||
LPAD(JB_NapHooAmt, 11, '0') || JB_Check3 ||
LPAD(JB_BonSe, 11, '0') ||
LPAD(JB_DosiSe, 10, '0') ||
LPAD(JB_SiNongSe, 10, '0') ||
LPAD(JB_KyoSe, 11, '0') || JB_MagamDate || JB_Check4 || JB_Gubun || JB_FIL1 || JB_Check5
|| JB_JobDate || JB_BlockNum || LPAD(jb_seqnum, 6, '0') ||
CASE WHEN JB_Gubun = '7' THEN '1'
WHEN JB_Gubun = '9' then '3'
END as SinguGubun
FROM TM_Jibang, TB_BranchInfo
WHERE
JB_JobDate = :szSunap
AND JB_DocID <> '1'
AND JB_SEMOK1 <> '30'
AND JB_ARK <> 'D'
AND JB_ARK <> 'R'
AND JB_SEMOK1 IN('10', '20', '50', '60', '70')
AND BR_BKBRCode = JB_IlgyeBRCode
AND JB_CONVGUID NOT IN ('710', '720')
AND JB_BLOCKNUM < '899'
ORDER BY
JB_ConvGuID, JB_SunapGubun, JB_BlockNum, JB_SeqNum;
System default option values taken from: /oracle2/product/10/precomp/admin/pcscfg.cfg
Syntax error at line 794, column 13, file fc_soinj.pc:
Error at line 794, column 13 in file fc_soinj.pc
(SELECT HD_Date FROM TB_HolidayInfo
............1
PCC-S-02201, Encountered the symbol "HD_Date" when expecting one of the followin
g:
( ) * + - / . @ | at, day, hour, minute, month, second, year,
The symbol ")" was substituted for "HD_Date" to continue.
Syntax error at line 797, column 22, file fc_soinj.pc:
Error at line 797, column 22 in file fc_soinj.pc
AND ROWNUM <= 1 ) || jb_ichedate || jb_napgigub
un || LPAD(JB_Nap_TotAmt, 11, '0') || JB_Sido || JB_GuID || JB_Check1 || JB_Sem
ok1 || JB_Semok2 ||
.....................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 806, column 9, file fc_soinj.pc:
Error at line 806, column 9 in file fc_soinj.pc
CASE WHEN JB_Gubun = '7' THEN '1'
........1
PCC-S-02201, Encountered the symbol "WHEN" when expecting one of the following:
; , ( [ * ? | & < > + - / % . ^ | & == != <= >= << >> ++ --
->
Syntax error at line 0, column 0, file fc_soinj.pc:
Error at line 0, column 0 in file fc_soinj.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 fc_soinj.pc
PCC-F-02102, Fatal error while doing C preprocessing |