OraFAQ Forum: SQL & PL/SQL » How can i Raise message/exception on commit

Home » SQL & PL/SQL » SQL & PL/SQL » How can i Raise message/exception on commit

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

How can i Raise message/exception on commit [message #244769]

Thu, 14 June 2007 01:33

kukreja
Messages: 33
Registered: February 2007

Member

If i have some sql file and in that i have commit serveral time.
So can I change my session setting such as commit fired. Either exception is raised or user defined msg is raised without altering that sql file.

Report message to a moderator

Re: How can i Raise message/exception on commit [message #244777 is a reply to message #244769]

Thu, 14 June 2007 01:47

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Why in the hell do you want to raise an exception on commit? Question

What is your need?

Please always post your Oracle version (4 decimals).

Regards
Michel

Report message to a moderator

Re: How can i Raise message/exception on commit [message #244802 is a reply to message #244777]

Thu, 14 June 2007 02:47

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

There's not many options for on-commit processing. You haven't really told us what you want it for, so you can't be expecting a concise answer.

You might want to look into:

I have no idea whether any of these will help. Generally speaking though, if you come up with a requirement that is so poorly supported by the tool, either you've selected the wrong tool or you're doing it the wrong way. I strongly suggest you take a long hard look at what it is you are trying to achieve. Talk to your co-workers and collect opinions.

Ross Leishman

Report message to a moderator

Re: How can i Raise message/exception on commit [message #244844 is a reply to message #244769]

Thu, 14 June 2007 05:40

kukreja
Messages: 33
Registered: February 2007

Member

I have to test an API which is called where commit fails. Through automated testing.

So i was looking for some steps which i can use as pre step and then fire the utility so control flow goes in that error routine.

Also link provided is not working

Report message to a moderator

Re: How can i Raise message/exception on commit [message #244854 is a reply to message #244844]

Thu, 14 June 2007 06:20

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I never saw any commit fail.
I think if a commit fails than the db is about to crash.

Btw, links work for me.

Regards
Michel

Report message to a moderator

Previous Topic:	ORA-06502: PL/SQL: numeric or value error: character to number conversion error
Next Topic:	Pakage.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 19:02:45 CST 2024