Re: PL/SQL Package compile Problem

Hi Joe,

it is really a hard job compiling PL / SQL using sqlplus. A tool could help you. Hora 3 ($ 380) shows the source code with syntax highlighting in one window. If the the source code contains compilation errors the window is split into two parts. The lower window displays the oracle error text, the upper highlights the corresponding line of the source code. If you move in the error window to another error the upper window scrolls to the corresponding source code. You can download a free 30 days trial version from http://www.keeptool.com.

regards Jan Dieckmann

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 - 05:49:01 CST