Re: Timeout wihle calling stored procedure?

Sybrand Bakker wrote:
>
> "Andreas D. Bauer" <ggl.t.adb_at_neverbox.com> wrote in message
> news:846e24af.0204300016.71345d8d_at_posting.google.com...
> > I call a stored procedure in a ORACLE-database from MICROSOFT ACCCESS
> > VBA-Code.
> > Unfortunately there seems to be a timeout after aprox. 35 seconds.
> > With a test procedure just counting integers in a loop to simulate
> > waiting itīs the same.
> >
> > The procedure need a lot of time.
> >
> > What can I do?
>
> Post the source please and/or provide more detail.
> Your post now can be summed up as 'It doesn't work' without any further clue
> as to what is happening.
>
> Regards
>

Sybrand is right of course....

But to give you some ideas......

How long does the stored procedure take if executed is SQL*Plus? (if you don't know how to execute just the stored procedure in SQL*Plus, learn how before proceeding any further).

How long does your VBA routine take if
you replace your stored procedure with
SELECT 'X' FROM DUAL ?

-- 
Phil Singer                |    psinger1_at_chartermi.net
Oracle DBA

Go Wings!!!!!!!