| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Why is INSERT not working on that view?
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_at_WWK.DE]
>Sent: Wednesday, March 10, 2004 3:43 PM
>To: 'oracle-l_at_freelists.org'; '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_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
>-----------------------------------------------------------------
>
-- 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:22:21 CST
 |
 |