Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006

    Question Unanswered: Error during Execute sp with IMAGE parameter

    It is the first time that Im using IMAGE field type..

    I created a stored procedure that should return an IMAGE field back to a
    c-sharp program .
    (@OutImg IMAGE declared as an output parameter of the procedure.)
    (Select @OutImg = ImgFld from table)
    Well,I can compile it , but when execute i get this error :
    Msg 2739, Level 16, State 1, Line 14
    The text, ntext, and image data types are invalid for local variable.

    Is there something I can do ,OR should I use any cast/convert func to solve it ..?
    Many thanks.

  2. #2
    Join Date
    May 2004
    from 2005 BOL:

    text, ntext, and image parameters cannot be used as OUTPUT parameters, unless the procedure is a CLR procedure.

    So you'll have to return this in a record set, not in an OUT param.

Posting Permissions

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