INF: Function dbretname() Returns NULL

ID: Q110325

The information in this article applies to:

Microsoft SQL Server Programmer's Toolkit, version 4.2

SUMMARY

Function dbretname() will not return NULL for a stored procedure parameter name if the parameter name is not specified in a previous call to dbrpcparam() or in the SQL EXEC statement.

MORE INFORMATION

For example, executing the statement,


   declare @var int
   exec TESTPROC @PARAM1 = @var OUT

will result in dbretname( dbproc, 1 ) returning the value "@PARAM1".

While executing the statement,


   declare @var int
   exec TESTPROC @var OUT

will result in dbretname( dbproc, 1 ) returning NULL.

Additional query words: dblib db_library DB-Library rpc remote stored procedure
return param

Keywords : kbprg SSrvDB_Lib SSrvDoc_Err SSrvProg
Version : 4.2.5 | 4.2.5 | 4.2.5
Platform : MS-DOS OS/2 WINDOWS
Issue type :