Re: Error when trying to run profload.sql - please help

rsweet_at_solidsol.com (Ron Sweet) wrote in message news:<cb95325a.0110160435.18313a04_at_posting.google.com>...
> Can anyone shed light on why I'm unsuccessful at installing the
> Profiler package? The output is below:
>
> Thanks very much!
>
> Ron Sweet
> Solid Solutions Inc.
>
> ----------------------------------
>
> Connected to Oracle8i Release 8.1.7.0.0
> Connected as SYS
>
> SQL>
>
> Package created
>
> Grant succeeded
>
> Synonym dropped
>
> Synonym created
>
> 3
> 4
> :3 0
> 1
> 4
> 0
> 7
> 0
> 1
> 14
> 0
> 0
> 0 0 0 0 0 0 0 0
> 0 0 0 0 0 0 0 0
> 0 0 0 0
> 0
>
> ORA-00900: invalid SQL statement
>
> Warning: Package body created with compilation errors
>
>
>
> Testing for correct installation
> PACKAGE BODY sys.DBMS_PROFILER - missing or invalid
>
> PL/SQL procedure successfully completed
>
> SQL>
Hmmmmm
Check out the script. There may be an inadvertent blank line in the binary part. sql*plus will not buy that and spit an error, and IIRC, this one.

Hth,

Sybrand Bakker
Senior Oracle DBA Received on Thu Oct 18 2001 - 14:06:34 CEST