Stored proc output of VARCHAR(max)

spider1269

I'm calling a Stored Proc that is outputting a varchar(max) based on the parameters sent. The output is several lines of data (similar to a memo). I'm having issues when I try to process the output. The code is failing on the first line of code below with a 'This data type is not supported by C/SIDE. You can access data from any of the following data types: VT_VOID, ....'.

          lADOParameter := lADOCommand.CreateParameter('@Data_Final',200,2,20,TargetText);   //Addenda Entry DSN
          lADOCommand.Parameters.Append(lADOParameter);
          
          lADOCommand.Execute;
          
          TargetText.ADDTEXT(FORMAT(lADOCommand.Parameters.Item('@Data_Final').Value));

How can I access the varchar(max) and bring it in to NAV? I've looked at Bigtext but am open to any option.

Thanks,
Jon