Re: PL/SQL Package compile Problem

Sounds to me like you accidentally have two lines in the input file that say:

End WriteDocPkg;

What it sounds like to me is that this extra line is causing the package to be interpreted ('compiled') and then you have another 'unnamed' block starting that it then starts to work on, thus removing the large package out of the buffer. So, all you see is the small unnamed block code at the end.

Joe Condle wrote:

> First I am fairly new to PL/SQL programming(about six months). To
> compile a program. I get into sqlplus and type @xxx.pkg. If I get
> errors I type show errors and then list 20 30 to see where the error on
> line 25 is. All of a sudden while compiling a package containing three
> functions, I go to compile and get alot of errors on various lines.
> When I go to list them list 30. It says no such line. When I type list
> by itself which usually lists the whole progam. I get the last three
> lines.
>
> Begin
> NULL;
> End WriteDocPkg;
>
> What happened? I cant fix the errors because I can't list the program.
> This happened all at one time. Is there some switch I inadvertently
> turned on?
>
> Please Help
>
> -Joe
Received on Tue Dec 01 1998 - 01:28:13 CST