• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to read the procedure code using sp_helptext

 
Elizabath Lima
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

Would you please tell me how i can read the stored procedure code from my sybase database through a java program. I read about sp_helptext.
How can i use to get the procedure code?
I'm calling the procedure using call dbadmin.GetRecords(). How can i get the same procedures code using some java code?
 
Rob Spoor
Sheriff
Pie
Posts: 20611
63
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Tested in MSSQL, probably also works (with some tweaks perhaps) with SyBase.

This works for both views and stored procedures.
[ January 07, 2008: Message edited by: Rob Prime ]
 
Elizabath Lima
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes, It is working without any issues.
Thanks Rob
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic