Using a PL/SQL Subprogram Procedure.

Hi,

If I run

CREATE OR REPLACE PROCEDURE test(what char) IS
BEGIN
        insert into EMP (NAME) values (what); END;
/

the procedure compiles and runs OK, but if I try to compile referencing a table that belongs to another user :

CREATE OR REPLACE PROCEDURE test(what char) IS
BEGIN
        insert into FRED.EMP (NAME) values (what); END;
/

I get compile errors, is it possible to use a procedure to reference someone elses tables or any other objects ?

Mike Received on Thu Jun 06 1996 - 00:00:00 CEST