Why is INSERT not working on that view?
- From: "Daiminger, Helmut" <HELMUT.DAIMINGER@xxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>,"'LazyDBA.com Discussion'" <oracledba@xxxxxxxxxxx>
- Date: Wed, 10 Mar 2004 11:12:36 +0100
Hi!
I have created a view that looks like this:
SELECT
MODUS_JOB.ID AS WZ00IDTAFT,
MODUS_JOB.VID AS WZ00VORAFT,
MODUS_JOB.VNR AS WZ00IDTVSN,
MODUS_JOB.STATUSCODE AS WZ00STSAFT,
MODUS_JOB.BUNDLENAME AS WZ00CODEXT,
MODUS_JOB.STATUSTEXT AS WZ00TXTSTS,
MODUS_JOB.ERROR AS WZ00KEZFEH,
MODUS_JOB.JOBMODE AS WZ00MODJOB,
MODUS_JOB.DIRECTPRINT AS WZ00KEZSFD,
MODUS_JOB.DIRECTPRINTER AS WZ00CODSFD,
MODUS_JOB.CREATE_BY AS WZ00IDTSAA,
MODUS_JOB.CREATE_AT AS WZ00DATEST,
MODUS_JOB.EDIT_BY AS WZ00IDTSAB,
MODUS_JOB.EDIT_AT AS WZ00DATBEA,
MODUS_JOB.XML as WZ00DTASTK
FROM MODUS_JOB;
But if I try to issue an INSERT statement against that view, I get the error
message: ORA-01733: virtual column not allowed here.
Is there a workaround for that?
This is 9.2 on HP-UX.
Thanks,
Helmut
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
