Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

text as output type

Status
Not open for further replies.
mjd3000

mjd3000

Programmer
Joined
Apr 11, 2009
Messages
136
Location
GB
I need to return a text data type as my output type, but I get the error :

Invalid parameter 2 ('@FileLocation'): Data type 0x23 is a deprecated large object, or LOB, but is marked as output parameter. Deprecated types are not supported as output parameters. Use current large object types instead.


Can anybody help?
 
Sort by date Sort by votes
Use VARCHAR(MAX) instead of TEXT.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

coorsman
  • Locked
  • Question Question
Column Data Type.
Replies
9
Views
1K
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question Question
Adding Text to and XML Field
Replies
2
Views
436
grnzbra
grnzbra
Andrzejek
  • Locked
  • Question Question
Field types question
Replies
9
Views
930
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question Question
Will not show row with Line Type 2
Replies
17
Views
1K
Cpreston
Cpreston
Cpreston
  • Locked
  • Question Question
Update another column if text in another exists
Replies
4
Views
489
Cpreston
Cpreston

Part and Inventory Search

Sponsor

Back
Top