Home » SQL & PL/SQL » SQL & PL/SQL » Calling stored Procedures
icon7.gif   Calling stored Procedures [message #233173] Wed, 25 April 2007 02:04 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member



Hi Friends,

In oracle 9i db how can i call a stored procedures

From one user to other user. Is possible.possible means

give the coding of procedures.

Try this one..pls

Arun Laughing
Re: Calling stored Procedures [message #233174 is a reply to message #233173] Wed, 25 April 2007 02:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is not clear what you want to do.
Do you want to call from a user a procedure of another user?

Btw, did you start to read the book I gave you the link yesterday?

Regards
Michel

[edit: add the last sentence]

[Updated on: Wed, 25 April 2007 02:12]

Report message to a moderator

Re: Calling stored Procedures [message #233190 is a reply to message #233174] Wed, 25 April 2007 02:58 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
akkumar81, do you understand the principle of calling procedures and functions? The next step is to understand grants, roles, synonyms...

Again, I refer to the Oracle documentation.

MHE
Re: Calling stored Procedures [message #233195 is a reply to message #233190] Wed, 25 April 2007 03:09 Go to previous messageGo to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member


ok micheal nad maaher

Re: Calling stored Procedures [message #233198 is a reply to message #233195] Wed, 25 April 2007 03:21 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
You do understand what Michel and I are doing, right? There's no disrespect involved but rather than throwing a few lines of code at you, we try to make you understand the concepts behind your question. That way, you can deduct your own solutions next time. Teach a man to fish...

MHE
Re: Calling stored Procedures [message #233207 is a reply to message #233198] Wed, 25 April 2007 03:47 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
... and bore him to death.
Re: Calling stored Procedures [message #233209 is a reply to message #233207] Wed, 25 April 2007 03:53 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Laughing
Previous Topic: Is there any problem with this query?
Next Topic: about view
Goto Forum:
  


Current Time: Fri Dec 09 01:59:53 CST 2016

Total time taken to generate the page: 0.10361 seconds