Why is INSERT not working on that view? 2004-03-10 - By Naveen, Nahata (IE10)
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@(protected)]
>Sent: Wednesday, March 10, 2004 3:43 PM
>To: 'oracle-l@(protected) '; '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 (See ORA-01733.ora-code.com): 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@(protected)
>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
>-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
>
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
