UPDATE TABLE FROM ANOTHER [message #1024] |
Thu, 21 March 2002 10:03 |
Antoni
Messages: 8 Registered: February 2002
|
Junior Member |
|
|
Hi what's the problem in here? it says me:
The following error has occurred:
ORA-06550: line 21, column 2:
PLS-00103: Found "FROM" when looking for...
update productos_gescon t1
set
t1.ges_desc = t2.nombre1,
t1.ges_jer = t2.codigo_estadist,
t1.ges_ean_uni = t2.ean11_uc,
t1.ges_ean_caja = t2.ean11,
t1.ges_conlk = DECODE (t2.kilo_o_litro, 'K', t2.peso_neto, t2.volumen_neto),
t1.ges_uni_caja = t2.uvta_consumo,
t1.ges_pieza_caja = t2.piezas_por_caja
from eka_p_attrib_toni t2
where
t3.ges_codprod = to_number(substr(t1.producto, 1, length (t3.producto)-1))
and
t2.necesario_eureka = 'SI'
and
t2.tabla = 'MARA';
|
|
|
|
Re: UPDATE TABLE FROM ANOTHER [message #1029 is a reply to message #1024] |
Thu, 21 March 2002 19:42 |
nash
Messages: 10 Registered: February 2002
|
Junior Member |
|
|
where t3.ges_codprod = to_number(substr(t1.producto, 1, length (t3.producto)-1))
--------------
Check the above statement, you will find the error.
--------------
HTH
nash
|
|
|