| View previous topic :: View next topic |
| Author |
Message |
shyamsaravan
Beginner
Joined: 12 May 2010
Posts: 44
Topics: 12
Location: India
|
 Posted: Mon Oct 31, 2011 5:51 am Post subject: Sql 901 error |
 |
|
Hi;
Please help me on that below error..
| Code: |
UNSUCCESSFUL EXECUTION CAUSED BY A SYSTEM ERROR THAT DOES NOT PRECLUDE THE SUCCESSFUL EXECUTION OF SUBSEQUENT SQL STATEMENTS. SQLCODE=-901, SQLSTATE=58004, DRIVER=3.53.70DSRA0010E: SQL State = 58004, Error Code = -901
|
The Stored proc has update,Insert and delete qurey and doing for multiple records..
The Error usually comes rarely
Please help me on that
Thanks;
[/code] |
|
| Back to top |
|
 |
papadi
Supermod
Joined: 20 Oct 2009
Posts: 594
Topics: 1
|
|
| Back to top |
|
|
shyamsaravan
Beginner
Joined: 12 May 2010
Posts: 44
Topics: 12
Location: India
|
| Posted: Tue Nov 01, 2011 2:42 am Post subject: |
|
|
Thanks for the reply...
But,If the StoredProc has been compiled again means that Error would not come..
So that every time ,Has to compile the Proc again and again |
|
| Back to top |
|
|
papadi
Supermod
Joined: 20 Oct 2009
Posts: 594
Topics: 1
|
| Posted: Tue Nov 01, 2011 10:38 am Post subject: |
|
|
| Quote: |
But,If the StoredProc has been compiled again means that Error would not come..
|
Why would you believe this 
I believe the problem(s) have nothing to do with how many times the same code is (re-)compiled.
Have you read (and understood) all of info from the linked page?
It is more likely that this is due to the way the process has been designed and until a different approach is used, the problems will be intermittent.
_________________
All the best,
di |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
