I always get MGR-00072

From: Mio-Nino P. Marquez <mio.marquez_at_mailcity.com.nospam>
Date: Wed, 05 May 1999 14:30:00 +0800
Message-ID: <372FE568.A0386DC7@mailcity.com.nospam>

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 Received on Wed May 05 1999 - 01:30:00 CDT