Sqlplus timeout

From: Nanard <bsegonnes_at_free.fr>
Date: 9 Nov 2005 01:23:38 -0800
Message-ID: <1131528218.635603.166170@g44g2000cwa.googlegroups.com>

Hi,

My application is doing a select a a view. I have a Bash script which run Sqlplus using a .sql file. the query is done in this file.

I don't know how the view has been created, how it compute the rows... it's another application. I have no control over it.

I just need my script not to exit in timeout (ORA-12535).

Is it possible to change the timeout duration from the sqlplus commqnd line (parameter ?) or from inside my .sql file (PL/SQL command) ?

Thanks for the answers.

Bernard Received on Wed Nov 09 2005 - 03:23:38 CST