Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Viewing Stored Procedure in SQL plus

 
v ray
Ranch Hand
Posts: 223
  • 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
  • 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
  • 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!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic