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
Messages: 11
Registered: December 2012
Junior Member
Hi I have a procedure where my end result will give like


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
Messages: 21146
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
Messages: 1848
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 17 20:29:47 CDT 2017

Total time taken to generate the page: 0.13917 seconds