title: Oracle: Set Query Timeout
body: <p>i have a PL/SQL program which do a query to an AS400 database through Transparent Gateway. Sometimes the AS400 not responds to the query (may be network problems )and the PL/SQL program hangs.</p>
  
  <p>Is there any method to set a timeout to the Oracle query so that when certain amount of time passes an exception is risen?</p>