Q110325 - INF: Function dbretname() Returns NULL

INF: Function dbretname() Returns NULL

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 : kbprogramming
Issue type :
Technology : kbSQLServSearch kbAudDeveloper kbSQLServPTK420