Home » SQL & PL/SQL » SQL & PL/SQL » ref cursor with oracle procedure (oracle 10g)
ref cursor with oracle procedure [message #574148] Mon, 07 January 2013 07:28 Go to next message
rajmighty972
Messages: 11
Registered: December 2012
Junior Member
Hi I have a procedure where my end result will give like

INSERT INTO ABC(A,B,C,D,ID) SELECT 1,2,3,4,P_ID FROM BBC WHERE P_ID=300;

this is a bulk insert where having 30 records.if one record fail then nothing will be commited.
error willbe moved into my error log table.

I want the insert statement to be record by record and commit the successful one and move the error into error log table.

is there any possibilt of using ref cursor with it.


Re: ref cursor with oracle procedure [message #574149 is a reply to message #574148] Mon, 07 January 2013 07:40 Go to previous messageGo to next message
Littlefoot
Messages: 19520
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Have a look at OraFAQ article DML Error Logging. Doing so, you'll learn some new keywords which will enable you to search further, if necessary.
Re: ref cursor with oracle procedure [message #574154 is a reply to message #574148] Mon, 07 January 2013 08:20 Go to previous message
flyboy
Messages: 1770
Registered: November 2006
Senior Member
@Littlefoot: Although repeating is the mother of wisdom (I do not know how is how to translate this proverb to English), I am afraid it is not applicable to the original poster: http://www.orafaq.com/forum/t/185568/0/

@rajmighty972: If you want to decrease performance of your application, use that (slow by slow) way.
Previous Topic: Count characters
Next Topic: Oracle Partition - 11g
Goto Forum:
  


Current Time: Thu Aug 28 06:55:41 CDT 2014

Total time taken to generate the page: 0.11994 seconds