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

Report message to a moderator

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.

Report message to a moderator

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

Report message to a moderator

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?

Report message to a moderator

Previous Topic: listener fail
Next Topic: SQLNET.AUTHENTICATION_SERVICES
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 25 10:50:46 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.