OraFAQ Forum: Server Administration » New to Oracle:How do I download a package.proc

Home » RDBMS Server » Server Administration » New to Oracle:How do I download a package.proc

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

New to Oracle:How do I download a package.proc [message #369936]

Wed, 08 November 2000 13:05

carrie
Messages: 2
Registered: November 2000

Junior Member

Hello,

There is an error in a package.procedure and I need to view the code. How does one do that??? Is there a way to download it?

Many Thanks in Advance,
Carrie

Report message to a moderator

Re: New to Oracle:How do I download a package.proc [message #369944 is a reply to message #369936]

Thu, 09 November 2000 05:03

Babu Paul
Messages: 38
Registered: November 2000

Member

Hi!
Yes, you can. Please issue the following query. Perhaps you can spool the query result to a file so that you can view it later. Substitute the name of the file and package_name with your own filename and the name of your package
SET pagesize 1000 heading off
SPOOL filename
SELECT text FROM all_source WHERE
name=upper('PACKAGE_NAME') ;
SPOOL OFF

Mind if the package exists in so many schemas(more than one). You will get repeated text.

However you cannot view the package body if it is hidden.

Good Luck!
Babu Paul

Report message to a moderator

Previous Topic:	Implict date conversion
Next Topic:	replace single quote

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 03 17:33:53 CDT 2024