Re: plsql webtoolkit newbie question

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 Finland Received on Fri Feb 11 2000 - 02:07:35 CST