Hi All,

Could anyone let me know how to use a synonym in a stored procedure.

I have created a public synonym for a remote table on a different schema.

Im now trying to use the synonym to load that data into a temporary table in my schema using a stored procedure and im getting an error.

Please let me know how to use a synonym in a stored procedure.

Thanks
Vishal

do Public have execute privilege on public synoym ?

how do i check whether it has execute privilages.

when i use the select * from <synonym name> i'm getting the record set.

why dont you put the error? or an example? or anything?

Hi,

>> how to use a synonym in a stored procedure.

The synonym applies to SQL, and the synonym is stored in the data dictionary:



Omce defined, you can reference the synonym anywhere, in PL/SQL or external programs.

See here for details:

http://www.dba-oracle.com/concepts/synonyms.htm

Remember, a synonym just just a device to allow multiple names for the same object, nothing more.

>> and im getting an error.

What error message?

Execute the below from SYS or Table_owner

GRANT ALL ON <TABLE> to <SYNONYM_OWNER> ;