Home » RDBMS Server » Networking and Gateways » Server/client
Server/client [message #184543] Thu, 27 July 2006 00:18 Go to next message
Anisasama
Messages: 17
Registered: June 2006
Location: karachi, Pakistan
Junior Member

hi,

We have server side procedure and many clients are using procedure with out alias or public synonym.Problem is occcuring one client and procedure is not compiling and returning error.If we use <schema name>.<procedurename> then it is compiling.
can anybody tell the actual problem that the client have?

please resolve its very urgent.

Regards
Anisa
Re: Server/client [message #184613 is a reply to message #184543] Thu, 27 July 2006 04:14 Go to previous messageGo to next message
aciolac
Messages: 242
Registered: February 2006
Senior Member
Problem is simple, and you already are write cause of them - You are not use synomyms. Only owner of the procedure can see them simply as <procedure_name>(in 9i and upper also can use alter .. set default scheme expression to change your default scheme). For any other user in database, procedure are visible only as <owner_name>.<procedure_name>. Use synonyms to resolve situation.
Re: Server/client [message #184627 is a reply to message #184613] Thu, 27 July 2006 04:45 Go to previous messageGo to next message
Anisasama
Messages: 17
Registered: June 2006
Location: karachi, Pakistan
Junior Member

Thanks! but procedure was working fine earlier without synonym creation, but now procedure is returing error. I want to know the actual cause
Re: Server/client [message #184668 is a reply to message #184543] Thu, 27 July 2006 07:11 Go to previous message
aciolac
Messages: 242
Registered: February 2006
Senior Member
Remind what was changed from last time, when application as worked. Are there was synonyms, and was dropped? Are you worked in application under the owner of procedure, or no?
Previous Topic: listener fail
Next Topic: SQLNET.AUTHENTICATION_SERVICES
Goto Forum:
  


Current Time: Tue Dec 06 08:20:59 CST 2016

Total time taken to generate the page: 0.06598 seconds