Re: [Basic Q] Creating package... getting error...

In article <3764FC65.8E891633_at_xmission.com>,   James Knowles <kaa_at_xmission.com> wrote:
>
> I'm quite comfortable with basic SQL (create/drop table,
> select/insert/update), but am trying to expand beyond this and create
a
> package and use user-defined types for the first time. After mulling
> through my copy of ORACLE8 PL/SQL Programming, I put a package header
> and body together. After running the SQL code in sqlplus, I got the
> message "Warning: Package created with compilation errors."
>
> I've reduced it to something very simple, but still get the message.
> 1) Is there something obviously wrong with the code?
> 2) How do I find out what these mysterious complation errors are? It's
> easier to debug when one knows *what* the errors are!
>
> This works:
>
> CREATE OR REPLACE PACKAGE Test AS
> END Test;
>
> This gives the mystery message:
>
> CREATE OR REPLACE PACKAGE Test AS
> DECLARE
> SUBTYPE t_Test1 IS DATE;
> SUBTYPE t_Test2 IS DATE;
> END Test;
>
> Thanks alot!
>
> --
> It's coming... http://www.countdown9199.com
>

Use "show errors" from the sqlplus prompt to see the error messages. You can also put the "show errors" in the end of package inside your pl/sql file.

Anyway "declare" is unwanted after "create or replace <name> as ". I think that is the error

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jun 14 1999 - 09:39:58 CDT