This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Viewing Stored Procedure in SQL plus

 
v ray
Ranch Hand
Posts: 223
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I can't believe this is happening to me, but I cant see the code for a particular stored procedure in SQL plus!!
what is the command to do so?
obviously desc procedure_name; isnt working for me!
I've looked all over the place and every website teaches you to create procedures, but how on earth do I view an already written one!!??
 
Lukasz Koniecki
Greenhorn
Posts: 1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
desc <package_name>

or if you want to get code of your package

select text from user_source where name = '<package_name>';
 
v ray
Ranch Hand
Posts: 223
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
select text from user_source where type='PROCEDURE' and name='PROCEDURENAME';

Yes!!! This is the one .
Thanks a lot!
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic