syntax to see the package code [message #344956] |
Tue, 02 September 2008 00:29  |
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 #344964 is a reply to message #344961] |
Tue, 02 September 2008 00:44   |
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   |
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 #345007 is a reply to message #344967] |
Tue, 02 September 2008 02:28  |
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.
|
|
|