Re: I always get MGR-00072

You have to create the table "worker" before you can compile the PL/SQL. and yes, use the "or replace" option because it would fail the second time anyway.

David Russell

On Thu, 06 May 1999 10:18:20 +0200, Steffen Stellwag <Steffen.Stellwag_at_pcm.bosch.de> wrote:

>Mio-Nino P. Marquez wrote:
>>
>> Hi.
>>
>> I've been starting to learn PL/SQL lately. I have several books on
>> Oracle for reference purposes.
>> In these books there are several PL/SQL code samples that I tried to run
>> but I always get MGR-00072. Warning: PROCEDURE <xxx> created with
>> compilation errors.
>>
>> For example, this sample PL/SQL will get that MGR-00072 warning message:
>>
>> CREATE PROCEDURE NEW_WORKER (PERSON_NAME IN VARCHAR2)
>> AS
>> BEGIN
>> INSERT INTO WORKER (NAME, AGE, LODGING) VALUES (PERSON_NAME, NULL,
>> NULL);
>> END;
>>
>> If I try to ignore the warning and try to execute the procedure (execute
>> New_Worker ('Mio')), I end up getting:
>>
>> ORA-06550: line 2, column 2:
>> PLS-00905: object SYSDBA.NEW_WORKER is invalid
>> ORA-06550: line 2, column 2:
>> PL/SQL: Statement ignored
>>
>> I'm creating/running the procedure using SQL Worksheet, and am
>> connecting to Oracle 8.
>>
>> Am I missing something here?
>>
>> Please help.
>>
>> Mio Marquez
>> Delphi Developer
>
>
>try CREATE OR REPLACE PROCEDURE NEW_WORKER
Received on Tue May 18 1999 - 18:26:19 CDT