ORA-00904
From: Ashish Namdeo <total_junk123_at_rediffmail.com>
Date: 8 Aug 2003 04:25:06 -0700
Message-ID: <a340bef3.0308080325.35caae9b_at_posting.google.com>
Date: 8 Aug 2003 04:25:06 -0700
Message-ID: <a340bef3.0308080325.35caae9b_at_posting.google.com>
I get the following error:
ORA-00904: invalid column name
When I run the following insert command:
INSERT INTO XXCUS_VGL_VST_MSTR
X(VISIT_ID,VISIT_DT_FROM,VISIT_DT_TO,EMP_NAME,EMP_NO,EMP_DESGN,VISIT_TYPE,LOCATION,SPECIAL_OBSERVATION,LAST_UPDATE_DT,LAST_UPDATED_BY)
VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11) RETURNING
X.ROWID,REF(X),X.VISIT_ID,X.VISIT_DT_FROM,X.VISIT_DT_TO,X.EMP_NAME,X.EMP_NO,X.EMP_DESGN,X.VISIT_TYPE,X.LOCATION,X.SPECIAL_OBSERVATION,X.LAST_UPDATE_DT,X.LAST_UPDATED_BY
INTO :12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24
The cursor highlights the error on X of REF(X). Could somebody throw
light on how to resolve the same.
Rgds,
Sebastian D
Received on Fri Aug 08 2003 - 13:25:06 CEST