Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 passing a text datatype to a stored procedure

Author  Topic 

kel
Starting Member

1 Post

Posted - 2002-10-24 : 23:57:04
Hi I'm trying to pass a variable with a text dataType to the sp_OASetProperty stored procedure (and would like to know how to do it for any other stored procedures). The problem being I need to pass more than 8000 characters.

ie

EXEC @resultcode = sp_OASetProperty @oMail, 'From', @Body

where @Body is a text Datatype

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-10-25 : 01:06:58
AFAIK you can't pass text variables to the sp_OASetProperty procedure. There are other methods for sending email on this site:

http://www.sqlteam.com/SearchResults.asp?SearchTerms=mail

Go to Top of Page
   

- Advertisement -