oerr 6508

From: Kevin Morris <krmorris4_at_hotmail.com>
Date: 6 May 2002 13:48:40 -0700
Message-ID: <dd21ecb8.0205061248.3be15eb8@posting.google.com>

I have an Oracle 8.1.6.3 database on Sun Solaris 2.6

I have an anonymous pl/sql block which calls a number of stored procedures. Within these procedures I drop/recreate some tables which makes some of the called stored procedures invalid, so I have a stored procedure that I call to compile them.

Anyway, I get a oerr 6508 pl/sql could not find the program unit being called when I try to call a particular procedure.

I know that the procedure is not invalid at this point in time, although it was invalid earlier. I have tried flushing the shared pool and I have tried simply rerunning the procedure when I get this error, but neither method works. If I exit sqlplus and then try again all works well.

So my question is - is there a way to avoid this error (I guess not) and when I get this error is there a way to correct or work around it without exiting my original sqlplus session

Thanks
Kevin Received on Mon May 06 2002 - 15:48:40 CDT