Re: Using a PL/SQL Subprogram Procedure.

Hello again,
I've just realised that if I grant ALL rights then I can compile the procedure to reference the other user's table !

Can anyone tell me why I could always reference it OK from a pl/sql block which is not a stored procedure ?

Mike

I said previously:

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