Viewing stored procedure code

abe6162 · #1 (**permalink**) 10-11-04, 13:23

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?

John Richter · #2 (**permalink**) 10-11-04, 16:02

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.