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....
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

     

    • nmrao's avatar
      nmrao
      Community Hero
      9 years ago
      Do you want to check that UpdateCount is 1?
      • soapuici's avatar
        soapuici
        Occasional Contributor
        9 years ago

        No.
        I have already mentioned:

         

        I need to assert "out parameter" of procedure.

        P_OUTPARAM1