anyone know what the problem is???

[joeythelips]

Hi,

I'm getting an error message when i run the sql below.
Does anyone know why?

SQL> desc abm_hendelse
Name Null? Type
----------------------------------------- -------- ------------------
KUNDE_ID NOT NULL NUMBER(8)
ABM_LOPENR NOT NULL NUMBER(4)
LOPENR NOT NULL NUMBER(4)
TYPE VARCHAR2(4)
BESKRIVELSE VARCHAR2(35)
HENDELSE_DATO DATE
STATUS VARCHAR2(4)
AVSLAG NUMBER(1)

SQL> UPDATE KUNDE
2 SET KUNDE.NAVN = PRE_LEV_DATO.NAVN
3 where kunde.kunde_id = pre_lev_dato.kunde_id
4 and pre_lev_dato.kunde_id = abm_hendelse.kunde_id
5 and ABM_HENDELSE.HENDELSE_DATO = '26/2/2002'
6 AND ABM_HENDELSE.TYPE = 'M_3';
AND ABM_HENDELSE.TYPE = 'M_3'
*
ERROR at line 6:
ORA-00904: invalid column name

 

[lewisp]

TYPE is a reserved word (I think). Change the column name in your table.

 

[joeythelips]

Thanks,

But what do you mean by a reveresed word?

 

[joeythelips]

Get u now. Reserved like date, number etc!!

Thanks,