mssql_execute(): stored procedure execution fail

I have try to access the stored procedure via PHP. But I keep getting errors like this:

Warning: mssql_execute(): stored procedure execution failed in /home/helloweb/public_html/2005/z_sp.php on line 18


my code is bellow .... can some one help me out this please i am using apache with latest php version

PHP Code:
<?php
    include "class_db.php";
    $conn = new classDb;

    $conn->remoteConnect();

    //----STORED PROCEDURE-----

    $sp = mssql_init("usr_SPOrderStatus");

    $customerurn = "0000226556";

    //mssql_bind ($sp, "@CustomerUrn", &$customerurn, SQLVARCHAR, TRUE, FALSE, 10);
    mssql_bind ($sp, "@CustomerUrn", $customerurn, SQLVARCHAR);
    


      $result = mssql_execute($sp);
    

    die();






    $ordernumber = "";
    $itemseq = "";
    $itemdate = "";
    $itemdesc = "";
    $status = "";
    $despatchdate = "";
    $cancelleddate = "";
    $consignmentnumber = "";


      //unset($stmt);  // <---VERY important

    $num = 0;
    mssql_bind($sp, "RETVAL", $num, SQLINT2);

    mssql_bind ($sp, "@OrderNumber", &$ordernumber, SQLVARCHAR, TRUE, FALSE, 14);
    mssql_bind ($sp, "@ItemSeq", &$itemseq, SQLVARCHAR, TRUE, FALSE, 4);
    mssql_bind ($sp, "@ItemDate", &$itemdate, SQLVARCHAR, TRUE, FALSE, 14);
    mssql_bind ($sp, "@ItemDescription", &$itemdesc, SQLVARCHAR, TRUE, FALSE, 60);
    mssql_bind ($sp, "@Status", &$status, SQLVARCHAR, TRUE, FALSE, 30);
    mssql_bind ($sp, "@DespatchDate", &$despatchdate, SQLVARCHAR, TRUE, FALSE, 14);
    mssql_bind ($sp, "@CancelledDate", &$cancelleddate, SQLVARCHAR, TRUE, FALSE, 14);
    mssql_bind ($sp, "@ConsignmentNumber", &$consignmentnumber, SQLVARCHAR, TRUE, FALSE, 20);



print("
CustomerUrn
VARCHAR(10)

OrderNumber
VARCHAR(14)

ItemSeq
VARCHAR(4)

ItemDate
DATETIME

ItemDescription
VARCHAR(60)

Status
VARCHAR(30)

DespatchDate
DATETIME

CancelledDate
DATETIME

ConsignmentNumber
VARCHAR(20)
");







    $conn->remoteDisconnect();

?>

 

 

 

 

Top