06-23-2008, 09:29 PM
Hi,
I created a function with query on a DB; sometimes I obtain errors, such as "ORA-00020: maximum number of processes (%s) exceeded"
obviously indipendent from the script.
Which instruction can I use to manage this error (and eventual similar) repeating automatically the function?
[is it possible to set a fixed number of attempts to repeat the function when there is an error?]
thanks a lot
PS: 'On error resume next' is insufficient in my need because bypasses error without retry
I created a function with query on a DB; sometimes I obtain errors, such as "ORA-00020: maximum number of processes (%s) exceeded"
obviously indipendent from the script.
Which instruction can I use to manage this error (and eventual similar) repeating automatically the function?
[is it possible to set a fixed number of attempts to repeat the function when there is an error?]
thanks a lot
PS: 'On error resume next' is insufficient in my need because bypasses error without retry