Forum PHP.pl

Hej,

Mam w bazie taka procedure

[SQL] pobierz, plaintext 
CREATE PROCEDURE DBO.SP_ChatRecruit_CheckLoginStatus(@StaffNo     VARCHAR(5),
                                                     @LoginStatus INTEGER     OUTPUT)  AS IF NOT EXISTS(SELECT [STAFFNO] FROM Staff_Active WITH (NOLOCK) WHERE StaffNo = @StaffNo)
  BEGIN /* OPERATOR DOES NOT HAVE AN ENTRY IN Staff_Active - SET LOGIN STATUS TO 0 - NOT LOGGED ON */
    SELECT @LoginStatus = 0
  END
ELSE
  BEGIN /* OPERATOR IS LOGGED ON TO WORK - SET LOGIN STATUS = StatusID FROM Staff_Active */
    SELECT @LoginStatus = StatusID FROM Staff_Active WITH (NOLOCK) WHERE StaffNo = @StaffNo
  END
GO
[SQL] pobierz, plaintext 

W PHP za pomoca PDO probuje takiego wywolania:

[PHP] pobierz, plaintext 
<?php
$st = IVR_PDOgetInstance()->query("
                DECLARE @Out INTEGER;
                EXEC SP_ChatRecruit_CheckLoginStatus '30383', @Out OUTPUT;
                SELECT @Out AS OutVal;
            ");
            $st->execute();
            dumpArray($st->fetch(PDOFETCH_ASSOC),1);
?>
[PHP] pobierz, plaintext 

Za kazdym razem dostaje pusta tablice.

Ma ktos pomysl gdzie lezy problem?