I get the following error:
ORA-00904: invalid column name
When I run the following insert command:
INSERT INTO XXCUS_VGL_VST_M STR
X(VISIT_ID,VISI T_DT_FROM,VISIT _DT_TO,EMP_NAME ,EMP_NO,EMP_DES GN,VISIT_TYPE,L OCATION,SPECIAL _OBSERVATION,LA ST_UPDATE_DT,LA ST_UPDATED_BY)
VALUES (:1,:2,:3,:4,:5 ,:6,:7,:8,:9,:1 0,:11) RETURNING
X.ROWID,REF(X), X.VISIT_ID,X.VI SIT_DT_FROM,X.V ISIT_DT_TO,X.EM P_NAME,X.EMP_NO ,X.EMP_DESGN,X. VISIT_TYPE,X.LO CATION,X.SPECIA L_OBSERVATION,X .LAST_UPDATE_DT ,X.LAST_UPDATED _BY
INTO :12,:13,:14,:15 ,:16,:17,:18,:1 9,: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
ORA-00904: invalid column name
When I run the following insert command:
INSERT INTO XXCUS_VGL_VST_M STR
X(VISIT_ID,VISI T_DT_FROM,VISIT _DT_TO,EMP_NAME ,EMP_NO,EMP_DES GN,VISIT_TYPE,L OCATION,SPECIAL _OBSERVATION,LA ST_UPDATE_DT,LA ST_UPDATED_BY)
VALUES (:1,:2,:3,:4,:5 ,:6,:7,:8,:9,:1 0,:11) RETURNING
X.ROWID,REF(X), X.VISIT_ID,X.VI SIT_DT_FROM,X.V ISIT_DT_TO,X.EM P_NAME,X.EMP_NO ,X.EMP_DESGN,X. VISIT_TYPE,X.LO CATION,X.SPECIA L_OBSERVATION,X .LAST_UPDATE_DT ,X.LAST_UPDATED _BY
INTO :12,:13,:14,:15 ,:16,:17,:18,:1 9,: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