Home » SQL & PL/SQL » SQL & PL/SQL » How can i Raise message/exception on commit
How can i Raise message/exception on commit [message #244769] Thu, 14 June 2007 01:33 Go to next message
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.
Re: How can i Raise message/exception on commit [message #244777 is a reply to message #244769] Thu, 14 June 2007 01:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: How can i Raise message/exception on commit [message #244802 is a reply to message #244777] Thu, 14 June 2007 02:47 Go to previous messageGo to next message
rleishman
Messages: 3724
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
Re: How can i Raise message/exception on commit [message #244844 is a reply to message #244769] Thu, 14 June 2007 05:40 Go to previous messageGo to next message
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
Re: How can i Raise message/exception on commit [message #244854 is a reply to message #244844] Thu, 14 June 2007 06:20 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
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

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


Current Time: Mon Dec 05 19:17:57 CST 2016

Total time taken to generate the page: 0.11823 seconds