Re: Designer/2000 - RMDBG package body invalid

Pat Driscoll wrote:

> Hi, I am trying to install Designer/2000 2.1.1 on an NT workstation 4.0
> machine. The repository resides on an HP/UX 10.2 server running
> Oracle8. I'm not able to successfully compile the package body RMDBG,
> which is owned by the repository owner (D2000 in my case). As far as I
> can tell, all grants have been successfully applied to D2000. I get
> multiple errors that have to do with the package sys.utl_file.
>
> The package body D2000.RMDBG compilation errors look like:
>
> PLS-00201: identifier 'UTL_FILE.FILE_TYPE' must be declared
> PL/SQL: item ignored
> PLS-00201: identifier 'UTL_FILE.IS_OPEN' must be declared
> PL/SQL: item ignored
> ...etc.
>
> I also copied the source file RMDBG.RPB from the distribution CD and
> tried again -- same results.
>
> Any Ideas? Thanks!
>
> ------------------------------------------------------------------------
>
> Pat Driscoll <pat.driscoll_at_lmco.com>
> Lockheed Martin Federal Systems
>
> Pat Driscoll
> Lockheed Martin Federal Systems <pat.driscoll_at_lmco.com>
> Netscape Conference Address
> Netscape Conference DLS Server
> Additional Information:
> Last Name Driscoll
> First Name Pat
> Version 2.1

Could try this

Log onto the database as the SYS user.
Grant execute on UTL_FILE to the repository admin user or to PUBLIC Create a public synonym UTL_FILE for the UTL_FILE package, viz

grant execute on UTL_FILE to repos_user; create public synonym UTL_FILE for UTL_FILE; Received on Wed Dec 16 1998 - 18:39:38 CET