Re: PL/SQL

Tim Vannaman wrote:
>
> Is there a single script or a series of scripts to install all the
> packages for PL/SQL in Oracle 7.2.3 on AIX.
>
> I installed it, but the standard package wasn't installed. I figured
> out which script to run, but I'm getting errors for the dbms_ouput.
> routines.
>
> Thanks,
>
> Tim.

Tim,

you need to run $ORACLEHOME/rdbms/admin/catproc.sql This should install all the packages for PL/SQL. Also in the same directory catalog.sql should be run (first perhaps, if you haven't run that script already).

Should work,
Ansgar

-- 
 Ansgar Seiter          	 Group Prof. Ch. Schlier      
 Department of Physics  	                             
 University of Freiburg 	 Phone:  +49 761 203-5730      
 Hermann-Herder-Str. 3  	 FAX:    +49 761 203-5873            
 D-79104 Freiburg i.Br  	 E-Mail: seiter_at_phya3.physik.uni-freiburg.de 
 Germany