Re: ORA-06509 for DBMS_LOB..

A copy of this was sent to A Dellelce <uh886_at_victoria.tc.ca> (if that email address didn't require changing) On Wed, 11 Aug 1999 17:28:00 +0200, you wrote:

>
>I received the following error:
>
>ORA-06509: PL/SQL: ICD vector missing for this package
>
>while trying to use the DBMS_LOB package on a Oracle 8.0.5/NT
>
>It seems that the DBMS_LOB package istalled is incompatible
>with the Oracle executable reading the Server Messages documentation.
>
>Do you know of a *correct* way of reistalling the DBMS_LOB
>package...
>
>I tried to drop the package and reinstall it using svrmgr30 (logging
>as internal) and the message is still there!!
>
>

find all copies of dbms_lob in your database and drop any that are not owned by SYS (internal). Verify the public synonyms then point to the ones owned by SYS.

>
>
>
>
>Thanks all!
>
>Antonio

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Aug 11 1999 - 10:40:15 CDT