Bug #16496: Stored Procedure Parameters is_null issue

From: arthur.mcgibbon@btinternet.com Operating system: Win2000 PHP version: 4.1.2 PHP Bug Type: MSSQL related Bug description: Stored Procedure Parameters is_null issue The problem is with executing a stored procedure with a null-value varchar output parameter. Steps... 1) create any SP that has a varchar(200) input/output param e.g. create procedure Test ( @TestVarchar varchar(200) = null output ) as select @TestVarchar = 'Successful parameter feedback'; 2) Run stored procedure using following statements... $ConnectionObj = mssql_connect($DB_SERVER_NAME, $DB_USER, $DB_PASSWORD); $aStatement = mssql_init("dbo.test", $ConnectionObj); mssql_bind($aStatement, "RETVAL", &$RetVal, SQLINT4); mssql_bind($aStatement, "@TestVarchar", &$Value, SQLVARCHAR, TRUE, TRUE, 200); $ExecResult = mssql_execute($aStatement); When PHP executes the SP it defines the parameter as VARCHAR(0) when it should be VARCHAR(200). I've run SQL Profiler and it shows... declare @P1 varchar(0) set @P1=NULL exec dbo.test @P1 output select @P1 when it should be declare @P1 varchar(200) set @P1=NULL exec dbo.test @P1 output select @P1 If you change the bind statement so that the @TestVarchar parameter is not null then the whole thing works. -- Edit bug report at http://bugs.php.net/?id=16496&edit=1 -- Fixed in CVS: http://bugs.php.net/fix.php?id=16496&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=16496&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=16496&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=16496&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=16496&r=support Expected behavior: http://bugs.php.net/fix.php?id=16496&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=16496&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=16496&r=submittedtwice