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)
 Return values in a Extended SP

Author  Topic 

misterraj
Yak Posting Veteran

94 Posts

Posted - 2005-03-10 : 03:20:37
I have created a Extended stored proc in C++. I call this ExtendedSP from the T-SQL(Normal stored proc) like this.

exec [Master].[dbo].csi_xp_env @param1,@return OUTPUT.

The extendedSP is running correctly, but I am not getting the @return parameter properly. In C++ I return a concatenation of strings liek this..

string csi_xp_env(param1)
{
;;;;
return("This is a test function")
;;;;
}

what I need is the @return parameter should return me this string "This is a test function".

Any ideas pls,

Thanks.
   

- Advertisement -