Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

cursor with insert into select statement

chijarJun 12 2008 — edited Jun 13 2008
dear 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 11 2008
Added on Jun 12 2008
5 comments
1,188 views