| Synonym for a synonym [message #101690] |
Wed, 20 March 2002 23:30  |
Synonymous
Messages: 2
Registered: March 2002
|
Junior Member |
|
|
I have a synonym SYMA pointing to a table TABA.
I am trying to create another synonym SYMB pointing to SYMA, so as to query TABA in my program.
The CREATE command executes successfully. But I am getting the following error at program runtime for SYMB:
ORA-00942: table or view does not exist.
When I try to create a synonym for TABA directly, it works fine.
What am I doing wrong?
Thanks.
|
|
|
|
| Re: Synonym for a synonym [message #101691 is a reply to message #101690] |
Mon, 25 March 2002 01:03  |
MOE
Messages: 14
Registered: February 2002
|
Junior Member |
|
|
why do you want to shoot by the chest in the eye?
Did you mix up private and public synonyms? Are there different users at program runtime? According to oracle documentation it must work.
MOe
|
|
|
|
| Re: Synonym for a synonym [message #101753 is a reply to message #101690] |
Sat, 07 February 2004 12:31 |
William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK
|
Senior Member |
|
|
Synonyms can be created even when the object referred to does not exist. If you replace the synonym in your program with the actual object name, does it run OK? Can you DESCRIBE the synonym from SQL*Plus?
Does this have anything to do with VMS?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
