Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    24

    Smile Unanswered: Viewing stored procedure code

    Hi,
    I am new to Sybase and I need some help. I have a stored procedure running on my Sybase database. I would like to see the code for this procedure to check for errors. How would I accomplish this?

  2. #2
    Join Date
    Oct 2004
    Posts
    3

    sp_helptext

    use the database that contains the stored proc
    then substitute the name of the proc where I have procname:
    sp_helptext procname

    Or if you have the Sybase Central admin tool in place, just browse to the proc, & right click.

    There is a setting that can hide all proc text, "select on syscomments.txt" and it is unlikely you have set it. And a stored proc that can hide text permanently, again unlikely that it has been invoked.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •