Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: update on nested table of substitutable value

Re: update on nested table of substitutable value

From: veselina <veselina.ovcharova_at_gmail.com>
Date: 15 Feb 2006 04:13:10 -0800
Message-ID: <1140005590.478932.120460@z14g2000cwz.googlegroups.com>

Antonio 6sette wrote:
> On 2006-01-30, Antonio 6sette <bottesini_at_libero.it> wrote:
>
> UPDATE (
> SELECT TREAT(VALUE(c) AS dip_var_vc2).valore cambiami
> FROM TABLE(SELECT dip_var FROM dipendenti
> WHERE id=1) c)
> SET cambiami = 'XXX';
>
> update (
> *
> ERROR at line 1:
> ORA-01733: virtual column not allowed here
>
> ?!
>
> --
> #include <stdio.h>
> int main(void){char c[]={10,65,110,116,111,110,105,111,32,98,97,114,98,111,110,
> 101,32,60,104,105,110,100,101,109,105,116,64,116,105,115,99,97,108,105,110,101,
> 116,46,105,116,62,10,10,0};printf("%s",c);return 0;}
Received on Wed Feb 15 2006 - 06:13:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US