Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Using public synonymes in stored procedures
Hi,
I have a problem with one pubilc synonyme I using in a stored procedures. I try to find the role of SP-execute-user with:
SELECT granted_role INTO sRolle FROM DBA_ROLE_PRIVS where grantee=(SELECT USER FROM DUAL);
But if I try to create the procedure with this statment, I get this error :
LINE/COL ERROR
But DBA_ROLE_PRIVS is a public synonyme. It means everone can read
this table.
I don't understand, what do I wrong?
Can anybody help me? Thanks in advance!
P.S. Sorry for my bad english! :-) Received on Fri Feb 16 2007 - 08:53:14 CST