Hello.
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.:ofrom 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.
Monday, March 26, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment