Forum Discussion

CDurkin's avatar
CDurkin
Contributor
13 years ago

ADO date parameters

In java script I am writing a test for the following SQL function: FUNCTION TEXT_DATE(p_Date IN DATE) RETURN VARCHAR2 IS     sDateText VARCHAR2(50); BEGIN     IF p_Date IS NULL THEN   ...
CDurkin's avatar
CDurkin
Contributor
13 years ago
If anyone is interested, my eventual working solutions was:




    var SProc = null, Rtn, Param;

    function TEXT_DATE(value)

    {   //FUNCTION TEXT_DATE(p_Date IN DATE) RETURN VARCHAR2;

        if (SProc == null)

        {

            SProc = ADO.CreateADOStoredProc();

            SProc.ConnectionString = SQLHelper.getConnectionString();

            SProc.ProcedureName = "TEXT_DATE";

            Rtn = SProc.Parameters.CreateParameter("RETURN_VALUE", DB.ftFixedChar, DB.adParamReturnValue, 1024, null);

            Param = SProc.Parameters.CreateParameter("p_Date", DB.ftDateTime, DB.adParamInput, 1024, null);

        }

        Param.Value = value;

        SProc.ExecProc();

        return Rtn.Value;

    }


 SProc = , Rtn, Param; TEXT_DATE(value)    {   (SProc == )        {            SProc = .CreateADOStoredProc();            SProc.ConnectionString = SQLHelper.getConnectionString();            SProc.ProcedureName = "TEXT_DATE";            Rtn = SProc.Parameters.CreateParameter("RETURN_VALUE", .ftFixedChar, .adParamReturnValue, 1024, );            Param = SProc.Parameters.CreateParameter("p_Date", .ftDateTime, .adParamInput, 1024, );        }        Param.Value = value;        SProc.ExecProc(); Rtn.Value;    }