cursor with insert into select statement
chijarJun 12 2008 — edited Jun 13 2008dear all
i know that i have to read the docs about this topic but im worried about this 'cause this is an urgent.
i want to create pls/sql cursor but i need help....
this is my insert into select statement but it need the line code that the errors about integrity will send to another table. i mean i want to manage the exceptions
INSERT INTO PLANELEC.PEMVX_REM (
V_NUMPAQTE,
V_NUMFORM,
V_CODDOCIDE,
V_NUMDOCIDE,
N_NUMORDEN,
MTO)
SELECT
"num_paq",
"formulario",
DECODE("cod_docide_dec",6,'09',1,'01',4,'06',7,'08',11,'04',NULL,'15','-','15',"cod_docide_dec"),
"num_docide_dec",
"norden",
TRUNC(TO_NUMBER(TRIM("mto_sctr_tributo"),'9999999999.9999'),2)
from planelec.t3514f@ORAAPOLO.REGRESS.RDBMS.DEV.US.ORACLE.COM
/
would you help me put the lines that i need in order to create cursor and manage the exceptions and integrity errors ???
thanks a lot !!!!
cesar