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 Thu May 06 1999 - 03:18:20 CDT
