wood burning stoves*
The moose likes JDBC and the fly likes PL SQL is just stopping at a SAVEPOINT - what can cause this to happen? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "PL SQL is just stopping at a SAVEPOINT - what can cause this to happen?" Watch "PL SQL is just stopping at a SAVEPOINT - what can cause this to happen?" New topic
Author

PL SQL is just stopping at a SAVEPOINT - what can cause this to happen?

Matt Kohanek
Village Idiot
Ranch Hand

Joined: Apr 04, 2009
Posts: 483

Here is the code:



The first insert statement runs, but the second does not in some situations. These are the very first lines in a procedure. Sometimes the code does get past this point (no need to go into all the gritty details about what makes it work and not work just yet I think - that would become a very long post...)

I am just wondering what could cause the code to just stop at the SAVEPOINT like that? Any references out there I can read that go into this?

Thanks


True wisdom is in knowing you know nothing - Socrates
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: PL SQL is just stopping at a SAVEPOINT - what can cause this to happen?