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_OBSERVATI ON,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,:2 4
The cursor highlights the error on X of REF(X). Could somebody throw
light on how to resolve the same.
Rgds,
Sebastian D