Re: problem with changing parameter lists

ttigger4321_at_hotmail.com (tony) writes:

> On Mon, 24 Jun 2002 15:30:53 GMT, Daniel Morgan
> >> Hi. We are periodically having problems after changing parameter
> >> signatures in pl/sql procedures. We do use "CREATE or REPLACE.." in
> >> the spec but still get a 404 from the browser when we try to access
> >> the page. This might happen for an hour or even longer but we have
> >> not been able to find any reason for it. Sometime changing the
> >> procedure name helps.
> >>

I have not done any plsql web pages yet, but at a guess I'd say your problem is due to Apache or your web browser or a "smart" proxy caching information which it then attempts to re-use and fails because the procedure/function signatrue/name has changed. I have seen similar problems with other web based solutions for dynamic pages.

One thing which might help is to use the http no-cache pragma. this http header pragma will tell proxy servers, web servers and browsers not to cache the page. Also look into the apache documentation as I would be very careful of options like keepalaive and those apache config options relating to url caching etc.

Tim Received on Mon Jun 24 2002 - 18:38:59 CDT