Forum Discussion

soapuici's avatar
soapuici
Occasional Contributor
7 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.

 

Thank you.

8 Replies

Sort By
  • nmrao's avatar
    nmrao
    Champion Level 3
    7 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
      7 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
        Champion Level 3
        7 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?