RE: Why is INSERT not working on that view?
- From: "Naveen, Nahata (IE10)" <Naveen.Nahata@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 10 Mar 2004 03:32:53 -0700
Is MODUS_JOB a view? AFAIK this error comes when you use a function like NVL
or DECODE in a view.
Regards
Naveen
>-----Original Message-----
>From: Daiminger, Helmut [mailto:HELMUT.DAIMINGER@xxxxxx]
>Sent: Wednesday, March 10, 2004 3:43 PM
>To: 'oracle-l@xxxxxxxxxxxxx'; 'LazyDBA.com Discussion'
>Subject: Why is INSERT not working on that view?
>
>
>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
>-----------------------------------------------------------------
>
----------------------------------------------------------------
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:
