From: total_junk123@rediffmail.com (Ashish Namdeo)
Newsgroups: comp.databases.oracle
Subject: ORA-00904
Date: 8 Aug 2003 04:25:06 -0700
Organization: http://groups.google.com/
Lines: 13
Message-ID: <a340bef3.0308080325.35caae9b@posting.google.com>
NNTP-Posting-Host: 203.145.163.44
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1060341907 26758 127.0.0.1 (8 Aug 2003 11:25:07 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 8 Aug 2003 11:25:07 GMT


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