Home » SQL & PL/SQL » SQL & PL/SQL » syntax to see the package code (9.0.4.0)
syntax to see the package code [message #344956] Tue, 02 September 2008 00:29 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member
Hi All,

Long back I have written one package. Now I want to see the code of that package. Can any one please let me know how to see that package . Is there any syntax for this.
I have given like

select * from user_source where package_name=<package name>

I want to get the code...

Please tell me how to see the code..

Thank you.
Re: syntax to see the package code [message #344957 is a reply to message #344956] Tue, 02 September 2008 00:32 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above

If you do not use CVS, then suffer with what you deployed.
Re: syntax to see the package code [message #344959 is a reply to message #344956] Tue, 02 September 2008 00:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
 Name                             Null?    Type
 -------------------------------- -------- ----------------------
 NAME                                      VARCHAR2(30)
 TYPE                                      VARCHAR2(12 CHAR)
 LINE                                      NUMBER
 TEXT                                      VARCHAR2(4000)

Regards
Michel
Re: syntax to see the package code [message #344961 is a reply to message #344959] Tue, 02 September 2008 00:37 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member
Michel,

I want to see the code what I have written. How to get it. Please let me know.

Thank you
Re: syntax to see the package code [message #344963 is a reply to message #344961] Tue, 02 September 2008 00:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Using your query but with the correct column name.

Regards
Michel
Re: syntax to see the package code [message #344964 is a reply to message #344961] Tue, 02 September 2008 00:44 Go to previous messageGo to next message
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
Senior Member
If you still do not know how to perform a simple query of a table then you should be looking into a new line of work. I cannot believe that you are still so ignorant as to continue to ignore the posting guidelines. Are you ignorant? or do you just lack the intelligence required to follow simple guidelines. Maybe you are so arrogant that you do not feel that the guidelines need to be followed when you post, or are you just deliberately trying to wind people up, to see how far you can go?

Quote:
select * from user_source where package_name=<package name>


Why on EARTH did you not just post the actual code that you used?
Re: syntax to see the package code [message #344966 is a reply to message #344959] Tue, 02 September 2008 00:54 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member
Michel,

Got it.. Thanks you very much for giving idea..
Select text from user_source
where name='PROCEDURE_NAME';

Previouly I am giving Procedure name in small letters..That's why am getting error.

Thank you.
Re: syntax to see the package code [message #344967 is a reply to message #344966] Tue, 02 September 2008 00:56 Go to previous messageGo to next message
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
Senior Member
Once again you refuse to follow the guidelines. I'm going to assume ignorance is the most likely from the above posted list.
Re: syntax to see the package code [message #345007 is a reply to message #344967] Tue, 02 September 2008 02:28 Go to previous message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Quote:

Previouly I am giving Procedure name in small letters..That's why am getting error.



Which we would have spotted in your FIRST post if you had posted the way you are supposed to. I start to believe 'ignorance' is to nice a word.
Previous Topic: case insensitive in data
Next Topic: creating new user
Goto Forum:
  


Current Time: Mon Feb 17 14:45:55 CST 2025