Re: plsql webtoolkit newbie question
Date: Fri, 11 Feb 2000 10:07:35 +0200
Message-ID: <38A3C347.E206442_at_gmx.de>
I have had the same problem.
Wait just a half or one hour the itīs work. I think there is
a internal cache which stored translated procedures and will
be
only refreshed sometime. If you have not anught time try to
rebuild all procedures and packages, or shutdown und startup
the database or (this is my way) reboot the system. If you
have a NT System for your database itīs also good for NT.
Its make
the system a little bit faster if you reboot it sometimes.
BUT IF THERE A BETTER WAY PLEASE LEt ME KNOW ABOUT IT
Immo
ahujad_at_my-deja.com wrote:
> OK. I've got the same problem, and it's quite
> annoying since I'm at a client's site developing a
> web application for them using Oracle 8.0x and OAS
> 4.x.
>
> I think that you're right; there may be a cache
> problem.
>
> Here's my scenario.
>
> I create and compile a procedure with no problem.
> Next I run it with no problem.
>
> Now I add a parameter to the procedure and
> re-create it. It seems to compile OK.
>
> But if I try to access it with the newly created
> parameter, it dies with this same error.
>
> As a work around, I rename the procedure to
> something new, and it works OK. Although this
> becomes very annoying and tedious, because I have
> to go through all the other procedures which
> access this one and modify them to call this
> renamed procedure.
>
> Does anyone know if there is a fix for this
> problem?
>
> Dil
>
-- ---------------------------------------------------------------------------- Immo Wetzel mailto:iwetzel_at_gmx.de Webpage: http://immo.home.pages.de Fachhochschule Stralsund http://www.fh-stralsund.de momently in FinlandReceived on Fri Feb 11 2000 - 09:07:35 CET