Re: Sometimes ORA-24388 problem - please advice

> >
> > J. Bijleveld
> > The Netherlands
> Cannot comment on why the error would occur, as my knowledge of
> .Net is very minimal.
> No doubt you already knew this:
> 24338, 00000, "statement handle not executed"
> // *Cause: A fetch or describe was attempted before executing a
> // statement handle.
> // *Action: Execute a statement and then fetch or describe the data.
>
> Undoubtly, you also know your version is not a pleasant one - at least
> upgrade, and patch to 8.1.7.4.
>
> As to the 5 minutes stuff - you seem to do something with Portal;
> if this would be Oracle Portal, there's a time-out on IP-address
> when all login attempts (3) have failed. IIRC, that is 5 minutes by
> default, but increases. Your login failure count is reset every 24hrs.

Hi Frank,

Thanks for your answer to my question, I did indeed find the error info you added below but I couldn't figure out in what why I would have to modify my stored procedure to make it work all of the time. It says "Execute a statement and then fetch or describe the data". In my opinion I already do so, please correct me if I'm wrong.

Thanks for your suggestion about the Oracle version, I'll make sure to have our customer check the patch-level so it's 8.1.7.4, if not, I'll send them the advice to check out that patch and apply it (if possible).

About the Portal: that's not the Oracle Portal (I should have mentioned that).
The application that uses Oracle is a framework to create portals.

Thanks again for your information,

Groeten,
Jeroen Bijleveld Received on Thu Feb 26 2004 - 08:24:45 CET