OraFAQ Forum: SQL & PL/SQL » rejected row capture

Home » SQL & PL/SQL » SQL & PL/SQL » rejected row capture (oracle 11g under linux)

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

rejected row capture [message #614627]

Sat, 24 May 2014 02:42

knroy10
Messages: 31
Registered: July 2010
Location: kolkata

Member

Check constraint failure, foreign key failure data capture
and add rejected row into a log table.

Inside a function under a loop processing 10000 rows .
Any check constraint failure or foreign key failure bad data
Want to capture into log table .

Any code or idea will be help full.

Report message to a moderator

Re: rejected row capture [message #614628 is a reply to message #614627]

Sat, 24 May 2014 02:49

dariyoosh
Messages: 538
Registered: March 2009
Location: France

Senior Member

http://www.oracle-base.com/articles/10g/dml-error-logging-10gr2.php

Report message to a moderator

Re: rejected row capture [message #614632 is a reply to message #614627]

Sat, 24 May 2014 04:58

knroy10
Messages: 31
Registered: July 2010
Location: kolkata

Member

Thanks for the reply. It is very helpfull.
One more question could share some idea on Dml error logging in postgresql.
Although it is oracle forum, asking due to curicity.

Report message to a moderator

Re: rejected row capture [message #614634 is a reply to message #614632]

Sat, 24 May 2014 06:01

dariyoosh
Messages: 538
Registered: March 2009
Location: France

Senior Member

http://www.postgresql.org/docs/9.3/interactive/runtime-config-logging.html

Report message to a moderator

Re: rejected row capture [message #614636 is a reply to message #614632]

Sat, 24 May 2014 09:00

knroy10
Messages: 31
Registered: July 2010
Location: kolkata

Member

Thanks for the reply.
In my first post the requirement as stated,
How to do the same in postgresql.
What i want , In my function of postgresql want to add error message, column id into error tab table.
Fk and check Constraint failure.
Any suggestion.

Report message to a moderator

Re: rejected row capture [message #614637 is a reply to message #614636]

Sat, 24 May 2014 09:09

dariyoosh
Messages: 538
Registered: March 2009
Location: France

Senior Member

And based on what exactly, you think the PostgreSql documentation link I provided does not fulfil your requirement?

Report message to a moderator

Re: rejected row capture [message #614638 is a reply to message #614636]

Sat, 24 May 2014 09:58

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

This site is an Oracle one.
Post your question in an Postgres forum.
This topic is locked.

Report message to a moderator

Previous Topic:	Split column data
Next Topic:	Find number of consecutive days from a table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 09:13:04 CDT 2024