mfaine_at_knology.net (Mark) wrote in message news:<329dd608.0212030700.6c4a1974_at_posting.google.com>...
> I'm trying to create a stored procedure on an Oracle 7.3.2.1.0 Server.
> I am accessing this server via SQL Plus. I'm not sure that it makes
> any difference but I am accessing this server through a link from an
> Oracle 8.1.7 Server.
>
> -------------------------
> SQL*Plus: Release 8.1.7.0.0 - Production on Tue Dec 3 08:46:20 2002
>
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
>
>
> Connected to:
> Oracle7 Server Release 7.3.2.1.0 - Production Release
> PL/SQL Release 2.3.2.0.0 - Production
>
> --------------------------
>
> Description of table that is relevant to this procedure
> SQL> describe drgi_sheets
> Name Null? Type
> ------------------------------- -------- ----
> DOCUMENT_ID NOT NULL VARCHAR2(17)
> VOLUME VARCHAR2(5)
> SECTION VARCHAR2(5)
> ISSUE VARCHAR2(8)
> CHANGE VARCHAR2(7)
> SHEET NOT NULL NUMBER
> PATH NOT NULL VARCHAR2(254)
> ID NUMBER(10)
> ---------------------------------------------------------
>
> The package specification is being successfully created but the
> package body is not. I get nothing more than a vague error message:
>
> Warning: Package Body created with compilation errors.
>
> Can anyone spot what is the problem with this package body? Also, is
> there any way I can get usefull debugging information while I'm
> attempting to create the stored procedures?
>
> Thanks,
>
> __________________________________________________________________
> -- END --
Place a "show errors" after the end of the body so the errors display.
Also check out the ALL_, DBA_, and USER_ERRORS dictionary views which
hold the information you seek.
HTH -- Mark D Powell --
Received on Tue Dec 03 2002 - 16:02:22 CST
