| Stored Procedure [message #371894] |
Mon, 18 December 2000 10:08  |
Marcus Fernando
Messages: 34
Registered: September 2000
|
Member |
|
|
Hi, i am trying to do a simple stored procedure that atualize one table of an other schema on witch i have privilege of select, update, insert, delete. The code is:
CREATE OR REPLACE PROCEDURE AC_AVALIACAOENVIARLIDER (V_IDAVALIACAO PRODGREEN.AC_AVALIACAO.IDAVALIACAO%TYPE)
IS
BEGIN
UPDATE PRODGREEN.AC_AVALIACAO
SET PRODGREEN.AC_AVALIACAO.DTENVIOLIDERIMEDIATO=SYSDATE
WHERE PRODGREEN.AC_AVALIACAO.IDAVALIACAO=V_IDAVALIACAO;
COMMIT;
END;
Oracle gives me the error message:
PLS-00201: identifier 'PRODGREEN.AC_AVALIACAO' must be declared
PRODGREEN is the other schema on with i have the grants and my user is called PROC. What im i doing wrong ?
I tested the commands in sql*plus and i can make inserts, deletes, selects in this table !!!
|
|
|
|
| Re: Stored Procedure [message #371895 is a reply to message #371894] |
Mon, 18 December 2000 10:49  |
Marcus Fernando
Messages: 34
Registered: September 2000
|
Member |
|
|
|
I found more: My privileges on the schema PRODGREEN was given by a role. I droped the role and gave the privilege directly for the user and i successfuly compiled the stored procedure. The role was the default role for the user. I can't make this with roles ?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
