Why is INSERT not working on that view?

From: Daiminger, Helmut <HELMUT.DAIMINGER_at_WWK.DE>
Date: Wed, 10 Mar 2004 11:12:36 +0100
Message-ID: <706FB6D452A69442B8275372F22C191502DE8AD7@serv102.wwk.de>

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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Wed Mar 10 2004 - 04:10:18 CST