Re: Standard package unavailable

Michael Friedhoff wrote:
>
> I'm running an SQL script that's part of a product install, and Oracle
> keeps complaining that the STANDARD PACKAGE is not available.
>
> I just recently rebuilt the database, and the script worked fine before
> the rebuild. Is there something I need to do to explicitly install the
> standard package on a newly built database?
>
> The server I'm running is Oracle 7.0.16.4.0 on AIX 3.2.5
>
> =======================
> Michael G. Friedhoff
> RISCmanagement, Inc.
> =======================
> Ph. (212) 695-9494
> Fax (212) 695-9801
> =======================
> Email mike_at_riscman.com
> http://www.riscman.com
> =======================

Mike,

        You need to run 'catproc.sql' in your rdbms/admin directory. This is the script which will set up your standard package. It must be run for the procedural option to work.

Bill

-- 
THE PRECEDING REFLECTS THE VIEWS OF THE AUTHOR
AND NOT, NECESSARILY, THE VIEWS OF EDWARD JONES.