Home » SQL & PL/SQL » SQL & PL/SQL » Packages
icon9.gif  Packages [message #233216] Wed, 25 April 2007 04:03 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

Hi

How can I to list each procedure or function in Package and what procedures and functions It call

If a procedure did reference only constants in other package , How can I to know ?

How can i execeute a procedure from different schema?

Arun.. Mad

[Updated on: Wed, 25 April 2007 04:06]

Report message to a moderator

Re: Packages [message #233225 is a reply to message #233216] Wed, 25 April 2007 04:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
dba/all/user_dependencies and PL/SQL User's Guide and Reference.

Regards
Michel
Re: Packages [message #233226 is a reply to message #233225] Wed, 25 April 2007 04:29 Go to previous messageGo to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member


Michel,

Is possible execute a procedure from different schema?

Laughing
Re: Packages [message #233230 is a reply to message #233226] Wed, 25 April 2007 04:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
yes, if you are allowed to.
Re: Packages [message #233231 is a reply to message #233230] Wed, 25 April 2007 04:47 Go to previous messageGo to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member


micheal ,

Give to me some examples.How can i execeute a procedure from different schema.what are the grant are allowed.tell me clearly.I need sample code is better
Re: Packages [message #233232 is a reply to message #233231] Wed, 25 April 2007 04:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read PL/SQL User's Guide and Reference and Application Developer's Guide - Fundamentals.

We are not going to feed you all your life.
You have to learn how to fish.

Regards
Michel

[edit: links corrected]

[Updated on: Wed, 25 April 2007 05:09]

Report message to a moderator

Re: Packages [message #233234 is a reply to message #233231] Wed, 25 April 2007 04:51 Go to previous messageGo to next message
shanthkumaar
Messages: 156
Registered: February 2007
Location: india,chennai
Senior Member

hi,

check this

do check the refrence guide

{Edit:Michel>>>> sorry i was little late]

regards
shanth

[Updated on: Wed, 25 April 2007 04:55]

Report message to a moderator

icon7.gif  Re: Packages [message #233235 is a reply to message #233232] Wed, 25 April 2007 04:53 Go to previous messageGo to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member


michel,

Link is not working.send it correct
Re: Packages [message #233236 is a reply to message #233235] Wed, 25 April 2007 04:58 Go to previous messageGo to next message
shanthkumaar
Messages: 156
Registered: February 2007
Location: india,chennai
Senior Member

hi,

the same links


regards
shanth
Re: Packages [message #233238 is a reply to message #233235] Wed, 25 April 2007 05:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Links are corrected.
But you should find them by yourself as I already posted you.

Regards
Michel
Re: Packages [message #233248 is a reply to message #233238] Wed, 25 April 2007 06:33 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Did you also change the name of the links?
If not, akkumar81 should be ashamed of himself, because there still is this thing called Google!!
Previous Topic: simple procedure to load data from flat file into the table
Next Topic: Dynamic printing of contents of tables
Goto Forum:
  


Current Time: Thu Dec 08 04:10:49 CST 2016

Total time taken to generate the page: 0.09052 seconds