Re: Oracle Web App / PLSQL keeps crashing

Are you using ORA_UTIL.REDIRECT_URL's in you PL/SQL??? If so... I know what your problem is.

Its a known Oracle bug and they are supposed to have a patch out real soon. For now I worked around the problem by using the refresh META tags in the generated HTML page instead of the REDIRECT URL's and my WRB has been completely stable ever since.

I had the same symptoms as you, only I was OWAS 3.0.1.0.1 on NT and RDBMS 8.0.4 on NT. After a few REDIRECT_URL calls were generated by the PLSQL, static HTML pages would still be served by the listener, but as soon as you tried to get dynamic web pages via the PL/SQL cartridge, it just would time out.

Hope this helps!
 -Jon

Russell Fray wrote in message <35c1cd4f.363749341_at_news.u-net.com>...
>I'm running Oracle 8.0.4.0.0 on Solaris 2.6 and using Web Application
>Server 3.0 to extract data using PL/SQL procedures/packages.
>
>However, over the last couple of days I keep getting the error message
>'Internet Error' (with no other info) from the web front end when
>trying to access the pl/sql procedure.
>
>Shutting down the appropriate web listener and restarting solves the
>problem, but I obviously need to stop this from happening. The
>listener is still running after the error occurs, and non-pl/sql
>requests are still answered - the error only appears when trying to
>call pl/sql.
Received on Fri Jul 31 1998 - 16:32:47 CDT