OraFAQ Forum: Client Tools » Viewing stored proc code

Home » Other » Client Tools » Viewing stored proc code (Oracle Database 10g Release 10.2.0.3.0, Windows Server 2003)

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

Viewing stored proc code [message #326628]

Thu, 12 June 2008 02:23

smora
Messages: 59
Registered: May 2006

Member

Hi

I currently view stored proc code using SQLPlus, with the command 'select text from user_source where name = 'SP_NAME'';

This is unformatted and hard to read and edit. Is there a better way to view the code?

Thanks in advance
SM

Report message to a moderator

Re: Viewing stored proc code [message #326635 is a reply to message #326628]

Thu, 12 June 2008 02:30

Frank
Messages: 7901
Registered: March 2000

Senior Member

This should return formatted text.

The database-source should never be the source you edit. The idea is that you store the source outside the database, edit that, and then compile it into the db.

Report message to a moderator

Re: Viewing stored proc code [message #326637 is a reply to message #326628]

Thu, 12 June 2008 02:31

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If it is unformatted this because the original code is not formatted.
Lines in user_source is exactly the same as that was given at creation time.
So ask you developer to format their code.

Regards
Michel

Report message to a moderator

Re: Viewing stored proc code [message #326717 is a reply to message #326628]

Thu, 12 June 2008 06:59

boukerker
Messages: 11
Registered: January 2008
Location: Paris

Junior Member

if you looking for a free good tools there is SQLTools www.sqltools.net

Regards.

Report message to a moderator

Previous Topic:	Oracle Instance
Next Topic:	How to verify migrated data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 23 16:52:58 CST 2025