Forum Discussion

soapuici's avatar
soapuici
Occasional Contributor
9 years ago

How to make assertion of stored procedure out parameter in jdbc request?

Please help to make assertion of stored procedure out parameter in jdbc request.   In sql query I write an anonymous block which calls stored procedure. I need to make assertion of out parameters....
nmrao's avatar
nmrao
Community Hero
9 years ago
Please show the input to groovy script and what you need to assert. Otherwise, it is difficult to offer any kind of help.
  • soapuici's avatar
    soapuici
    Occasional Contributor
    9 years ago

    As I mentioned it is JDBC request. It is not groovy script.

     

    In sql query I wrote: (request is 

     

    DECLARE 
  P_ID_INPARAM VARCHAR2(32767);
  P_OUTPARAM1 NUMBER;
  P_OUTPARAM2 NUMBER;
BEGIN 
  P_ID_INPARAM := '${Properties#id}';
  P_OUTPARAM1 := NULL; --out
  P_OUTPARAM2 := NULL; --out
  SCHEMA1.PACKAGE1.PROCEDURE2 ( P_ID_INPARAM, P_OUTPARAM1, P_OUTPARAM2);
END

    This works fine. But I need to read the out parameters.

    And assert them.

    • nmrao's avatar
      nmrao
      Community Hero
      9 years ago
      Does it show any response for the same jdbc request is called? If so, can you post that along with what needs to be asserted?
      • soapuici's avatar
        soapuici
        Occasional Contributor
        9 years ago

        yes.

        the response is:

        <Results>
   <UpdateCount>1</UpdateCount>
</Results>

        Need to assert 

        P_OUTPARAM1