OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Bulk insert

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Bulk insert [message #284802]

Sat, 01 December 2007 05:40

Majaa
Messages: 5
Registered: May 2007
Location: Tamilnadu

Junior Member

I am using bulk insert in our procedure .Because of constraint violation ,only one record has failed to insert. But Complete insertion was failed .
can you tell me is there any way to insert other records using bulk update .

[Updated on: Sat, 01 December 2007 05:41]

Report message to a moderator

Re: Bulk insert [message #284803 is a reply to message #284802]

Sat, 01 December 2007 05:45

dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai

Senior Member

make use of SAVE EXCEPTIONS or may be look for DBMS_ERRLOG or the EXCEPTIONS table

regards,

[Updated on: Sat, 01 December 2007 05:59]

Report message to a moderator

Re: Bulk insert [message #284810 is a reply to message #284803]

Sat, 01 December 2007 06:33

Majaa
Messages: 5
Registered: May 2007
Location: Tamilnadu

Junior Member

Thanks . It is working fine after adding save exception

Report message to a moderator

Previous Topic:	ORA-00939 generated when creating a view in 10g
Next Topic:	Unwanted "object owner" in procedure causing ORA-04052 error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 17 05:21:01 CST 2025