oracle - ORA-01013 - Weblogic setting error? -

I am running a banking program that is coded in Oracle PL / SQL. This program runs for 2-3 hours every day as part of an end to off processing.

By yesterday, it was working fine. Today when I run it today, after about 30 minutes, the program ends with error ORA-01013: The user has requested to cancel the current operation . I'm not ending the program manually

I think this may be a weblogic setting (where the application has been deployed). I'm not fluent in weblogic and I'm not sure how the parameter can be changed to prevent this error. help please!

Oracle version: 11.2.0.3
Oracle Weblogic Server: 11G

It seems like a JDBC timeout; Services from WebLogic Console- & gt; Go to the data source and click on the name of your data source to view its settings, click the Connection Pool tab, and expand the Advanced section at the bottom of the page. From

to:

When statement timeout is set to -1, (default) statement is not timeout.

The behavior you are looking at has been suggested that the timeout is set to 1800 when the timeout expires after 30 minutes.

However, it will not change in itself, and if it is already set it was previously ignored, which would require some investigation - something else has changed?

Another possibility is that your code is making many calls within a 3-4 hour window, and one of them is longer than the deadline, it may be your case, if the case is less than 1800 is. Without looking at your code or the current timeout value, I'm clearly guessing.