On 2006-01-30, Antonio 6sette <bottesini@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,11 1,110,
101,32,60,104,105,110,100,101,109,105,116,64,116,1 05,115,99,97,108,105,110,101,
116,46,105,116,62,10,10,0};printf("%s",c);return 0;}