SQL code -905
SQL CODE -905
What is Sql code -905 ?
Sql code -905 is unsuccessful execution of Sql query due to
resource limit beign exceeded
When does sql code -905 comes?
Sqlcode -905 can come if the limit is exceeded for the resource.For example:- A system has a limit of CPU time alloted for aquery and if the time taken by a query exceeds this limit than sql code-905 will come.
How does system behave for sql code -905?
Execution of the query is terminated.
How to resolve sql code of-905?; ; ; ;
You can analyse why the time taken by the query is so much and you maywant to optimize the query or you can contact your system admin whotakes care of maintaining this resource limit.