Break execution SQL in Oracle procedure when preset time is out?

[Devil]

Who tell me please how break execution any sql query which execute a long time when preset time out?
Or set execution time limit for SQL
In DOA TOracleSession exists method BreakExecution which call OCI function, after this Oracle return error ORA-01013: user requested cancel of current operation.

I need do like this but only in Oracle(PLSQL).
Ask anyone, please.

 

[ldsandon]

Try to ask Tom... (asktom.oracle.com).

 

[Devil]

Thanks ldsandon