Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2002

    Unanswered: for passing text type argument to procedure

    For parsing data > 8000 char I have defined a procedure that looks something like
    create proc myproc @doc text
    blah blah blah

    but now i need to pass text argument to it.
    For that I need ::: declare @newdoc text
    and then call ::: exec myproc @newdoc
    but I cannot declare text type variable in the transact sql queries.

    Is there a way out

  2. #2
    Join Date
    Feb 2002
    Houston, TX
    you normally don't work directly with text, ntext and image data. When working with these types of data you normally pass pointers to the data and use functions/stored procedures to manipulate the data, TEXTPTR, WRITETEXT and UPDATETEXT. Check out "text and image data types" in Books On Line.
    Paul Young
    (Knowledge is power! Get some!)

Posting Permissions

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