Menu

#251 sp_helpText in sybase

closed-fixed
nobody
Core (462)
5
2006-10-31
2005-03-04
No

If I run an sp_helptext and then a stored procedure name,
it should return the content in stored procedure. It just
seems to show the number of lines of text and there is
now way or retrieving what that text is. Please could a
change be made so that the text can be shown.

By driver is: Sybase Adaptive Server Anywhere 12.5
(Syabes Central 3.2\java\Jaguar ASEPlugin.jar).

Discussion

  • Colin Bell

    Colin Bell - 2006-10-31
    • assigned_to: colbell --> nobody
     
  • Colin Bell

    Colin Bell - 2006-10-31
    • status: open --> closed-fixed
     
  • Colin Bell

    Colin Bell - 2006-10-31

    Logged In: YES
    user_id=233132

    Works in SQSC 2.3

    sp_helptext myproc

    text
    ----------------------------------------------------
    create procedure DBA.myproc as
    begin
    select* from bank
    return 0
    end

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.