Stored Procedure Help

[Tim Bachta]

I am using MS SQL 2000 as a database.  I am trying to run a stored
procedure using the following code:

 

<esql:execute-query>

  <esql:call>

    {? = call rptLocationDeviations(<esql:parameter direction="in"
type="Int"><xsp:expr>number</xsp:expr></esql:parameter>,<esql:parameter
direction="in"
type="String"><xsp:expr>room</xsp:expr></esql:parameter>,<esql:parameter
direction="in"
type="String"><xsp:expr>beginTime</xsp:expr></esql:parameter>,<esql:para
meter direction="in"
type="String"><xsp:expr>endTime</xsp:expr></esql:parameter>)}

  </esql:call>

  <esql:call-results>

    <esql:use-results>

      <esql:result><xsp:expr><esql:get-object column="1"
from-call="true"/></xsp:expr></esql:result>

       <esql:results>

         <esql:row-results>

          <test>

           <esql:get-string column="1"/>

          </test>

       </esql:row-results>

     </esql:results>

    </esql:use-results>

  </esql:call-results>

</esql:execute-query>

 

I am getting back an error message of invalid parameter bindings.  I
checked my input parameters and they are set up correctly.  Any
suggestions would be greatly appreciated.  

 

Thank you

 

Tim Bachta

 

 


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]