Hi all
I got one table and two views
* PREPAQ_MIC (Primary table)
* VW_DATACRED (view)
* VW_CNCH_MPIO (view)
The last view is defined:
CREATE OR REPLACE FORCE VIEW FIRA.VW_CNCH_MPIO
(CDGPROG, CDGEF, CDGMU)
AS
select CDGPROG, CDGEF, trim(column_value) CDGMU
from ( SELECT CDGPROG, CDGEF, APO.VALORES CDGMU
FROM FIRA.APL_APOYO APO
WHERE CDGPROG = 'CNCH' AND CDGMU = 'VAR'
ORDER BY CDGEF, CDGMU
) t,
XMLTABLE(('"' || replace(CDGMU, ',', '","') || '"'));
When i try to update the PRE.APOYO (table) with value from view CNCH.CDGPROG :
UPDATE /*+BYPASS_UJVC*/
(
SELECT PRE.CLNS, PRE.CDGCLNS, PRE.CICLO, PRE.CDGCL, PRE.APOYO AS PRE_APOYO, CNCH.CDGPROG AS APOYO_CNCH
FROM PREPAQ_MIC PRE,
VW_DATACRED VDC,
VW_CNCH_MPIO CNCH
WHERE
PRE.CLNS = VDC.CLNS AND PRE.CDGCLNS = VDC.CDGCLNS AND PRE.CICLO = VDC.CICLO AND PRE.CDGCL = VDC.CDGCL
AND VDC.CDGEF = CNCH.CDGEF AND VDC.CDGMU = CNCH.CDGMU
AND TRIM(PRE.APOYO) IS NULL
) SET PRE_APOYO = APOYO_CNCH
Get the error
ORA-01031: Privilegios insuficientes.
Note: if i execute the select query works fine....
Hope you can helpme
Thanks in advance....
Cheers!