Re: PL/SQL compilation

jared_at_valleynet.com (jared still) wrote:

>Reposting article removed by rogue canceller.
 

>Marco Savini <savim_at_info.isbiel.ch> wrote:
 

>>Hi
 

>>MGR-00072: Warning: PACKAGE BODY xyz created with compilation errors.
 

>>Well, you can imagine that this isn't very helpful for
>>a beginner. Is there a way to let the package compile
 

>>Marco Savini
>>savim_at_info.isbiel.ch
 

>The first thing you should do is try to find a copy of the manual for SQL*PLUS
>and READ IT!
 

>Try typing 'show errors' after compiling your package.

>jared still ---- ___o
>jared_at_valleynet.com ---- _`\ <,_
> ----- (*)/o (*)
>--------------------------------------

Jared:

Try not being a jerk.

Marco:

First things first. Make sure you have the procedural option installed on you server.
If not run CATPROC.SQL (See the oracle server administator's guides). A quick test to see if it's installed:

CREATE OR REPLACE PROCEDURE marco AS

        x VARCHAR2(10);
BEGIN

	IF x IS NULL THEN
		NULL;
	END IF;

You'll get an error message if you haven't installed Procedural Option yet.

Then try again.

Jon Vincenzo
jvince19_at_mail.idt.net Received on Fri Sep 27 1996 - 00:00:00 CEST