How to read the procedure code using sp_helptext

[Elizabath Lima]

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]

Tested in MSSQL, probably also works (with some tweaks perhaps) with SyBase.

String query = "exec sp_helptext ?";
PreparedStatement stmt = connection.prepareStatement(query);
stmt.setString(1, myViewName);
ResultSet rs = stmt.executeQuery();
StringBuilder b = new StringBuilder();
while (rs.next())
{
    b.append(rs.getString("Text"));
}
rs.close();
stmt.close();
System.out.println(b.toString());

This works for both views and stored procedures.
[ January 07, 2008: Message edited by: Rob Prime ]

[Elizabath Lima]

Yes, It is working without any issues.
Thanks Rob