I always get MGR-00072
Date: Wed, 05 May 1999 14:30:00 +0800
Message-ID: <372FE568.A0386DC7_at_mailcity.com.nospam>
Hi.
[Quoted] 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 - 08:30:00 CEST