Home » SQL & PL/SQL » Client Tools » Viewing stored proc code (Oracle Database 10g Release 10.2.0.3.0, Windows Server 2003)
Viewing stored proc code [message #326628] Thu, 12 June 2008 02:23 Go to next message
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
Re: Viewing stored proc code [message #326635 is a reply to message #326628] Thu, 12 June 2008 02:30 Go to previous messageGo to next message
Frank
Messages: 7880
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.
Re: Viewing stored proc code [message #326637 is a reply to message #326628] Thu, 12 June 2008 02:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Viewing stored proc code [message #326717 is a reply to message #326628] Thu, 12 June 2008 06:59 Go to previous message
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.
Previous Topic: Oracle Instance
Next Topic: How to verify migrated data
Goto Forum:
  


Current Time: Tue Dec 06 04:25:40 CST 2016

Total time taken to generate the page: 0.11187 seconds