OraFAQ Forum: SQL & PL/SQL » ref cursor with oracle procedure

Home » SQL & PL/SQL » SQL & PL/SQL » ref cursor with oracle procedure (oracle 10g)

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

ref cursor with oracle procedure [message #574148]

Mon, 07 January 2013 07:28

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.

Report message to a moderator

Re: ref cursor with oracle procedure [message #574149 is a reply to message #574148]

Mon, 07 January 2013 07:40

Littlefoot
Messages: 16924
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.

Report message to a moderator

Re: ref cursor with oracle procedure [message #574154 is a reply to message #574148]

Mon, 07 January 2013 08:20

flyboy
Messages: 1669
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.

Report message to a moderator

Previous Topic:	Count characters
Next Topic:	Oracle Partition - 11g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 18 08:42:21 CDT 2013

Total time taken to generate the page: 0.06681 seconds