Database Timeout ?

[GRAYTech]

DOA 4.01, Delphi 6-SP2, Oracle 9+. ASTA 3.1 (Stateless), RBServer 10.03

I've got a timeout error when running a stored procedure for longer than 30 seconds. I'm calling a stored proc voia an ASTA client (tastaclientdataset) which connects to an asta server using DOA components to ultimately execute the stored procedure.

The client doesn't wait for the stored proc to complete and produces an error - 'The operation has timed out' yet the stored procedure continues to run on the server and produce a temp table of results as expected.

So the client is just not waiting for the stored proc to complete. Is thera a DOA timeout setting for this?

 

[GRAYTech]

I should have also said when I run the same stored procedure via PL/SQL Developer it runs normally. PL/SQL waits for the proc to omcplete (several minutes) and produces the correct results.

 

[Marco Kalter]

Direct Oracle Access does not have any time-outs. Maybe it's an ASTA setting.