Home » SQL & PL/SQL » SQL & PL/SQL » Bulk insert
Bulk insert [message #284802] Sat, 01 December 2007 05:40 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
Majaa
Messages: 5
Registered: May 2007
Location: Tamilnadu
Junior Member
Thanks . It is working fine after adding save exception
Previous Topic: ORA-00939 generated when creating a view in 10g
Next Topic: Unwanted "object owner" in procedure causing ORA-04052 error
Goto Forum:
  


Current Time: Mon Dec 05 21:06:27 CST 2016

Total time taken to generate the page: 0.08445 seconds