Home » SQL & PL/SQL » SQL & PL/SQL » An error can any one help me (ORACLE 9i /WINDOWS)
An error can any one help me [message #294327] |
Thu, 17 January 2008 04:16  |
rakeshramm
Messages: 175 Registered: September 2006 Location: Oracle4u.com
|
Senior Member |

|
|
WITH PRB AS(
SELECT M.DT_REQDATE,M.DT_REQBY,M.NN_EXPERIENCE,M.NN_VACANCY,M.VC_NOTE,M.NN_SELECTED,
J.VC_JOBSPEC,QM.VC_QUALIFICATION,QM.C_DEGREE,QM.YN_TECHNICAL,D.VC_DESIGNATION,
M.C_REQSTATUS,M.NN_REQNO
FROM Hr_Man_Request_Mast M
LEFT JOIN HR_MAN_REQUEST_JOB J ON M.NN_REQNO=J.NN_REQNO
INNER JOIN HR_MAN_REQUEST_QUAL Q ON Q.NN_REQNO=M.NN_REQNO
INNER JOIN HR_QUALIFICATION_MAST QM ON Q.NN_QUALCODE=QM.NN_QUALCODE
INNER JOIN HR_DESIGNATION_MAST D ON(D.NN_DESGCODE=M.NN_DESGCODE) AND
M.DT_REQDATE BETWEEN &FDAT AND &TDAT)
SELECT DT_REQDATE FROM PRB WHERE C_REQSTATUS LIKE decode(&STAT,'O','O%','A','O%','Z')
UNION ALL
SELECT DT_REQDATE FROM PRB WHERE C_REQSTATUS LIKE decode(&STAT,'C','C%','A','C%','Z')
when i executing this query this error is obtaining can any one help me
ORA-00604: error occurred at recursive SQL level 1
ORA-00904: "from$_subquery$_003"."NN_REQNO_0_0": invalid identifier
but when i executing this query output is getting
WITH PRB AS(
SELECT M.DT_REQDATE,M.DT_REQBY,M.NN_EXPERIENCE,M.NN_VACANCY,M.VC_NOTE,M.NN_SELECTED,
J.VC_JOBSPEC,QM.VC_QUALIFICATION,QM.C_DEGREE,QM.YN_TECHNICAL,D.VC_DESIGNATION,
M.C_REQSTATUS,M.NN_REQNO
FROM Hr_Man_Request_Mast M,HR_MAN_REQUEST_JOB J,HR_MAN_REQUEST_QUAL Q
,HR_QUALIFICATION_MAST QM,HR_DESIGNATION_MAST D
WHERE M.NN_REQNO=J.NN_REQNO(+) AND Q.NN_REQNO=M.NN_REQNO AND QM.NN_QUALCODE=Q.NN_QUALCODE
AND D.NN_DESGCODE=M.NN_DESGCODE AND M.DT_REQDATE BETWEEN &FDAT AND &TDAT )
SELECT * FROM PRB WHERE C_REQSTATUS LIKE(decode(&STAT,'O','O%','A','O%','Z'))
UNION ALL
SELECT * FROM PRB WHERE C_REQSTATUS LIKE(decode(&STAT,'C','C%','A','C%','Z'))
|
|
|
|
|
Goto Forum:
Current Time: Mon Feb 17 15:09:01 CST 2025
|