Jelmer
Can you tell me how you defined the out variables in the JDBC Request
screen?
Thanks.
Jelmer de Haas wrote:
>
> I have managed to call the Stored Procedure (SP) on Oracle 10 from
> Jmeter.
>
> This SP (see below) returns three values. But in the Result Tree these
> are not shown, only respons is 'Executed'.
>
> Is there some way to show these values and do some kind of response
> assertion on them?
>
>
> DECLARE
>
> returnmessage VARCHAR(256);
> ipaddress VARCHAR(256);
> fnumber VARCHAR(256);
> brand VARCHAR(256);
> returncode NUMBER;
> creationdate NUMBER;
>
> BEGIN
>
> BLACKLISTIP ('[email protected]', '127.0.0.66', 'brand',
> returncode,returnmessage,creationdate);
> DBMS_OUTPUT.PUT_LINE(returncode);
> DBMS_OUTPUT.PUT_LINE(returnmessage);
> DBMS_OUTPUT.PUT_LINE(creationdate);
>
> END;
>
>
> Regards,
> Jelmer
>
>
>
--
View this message in context:
http://www.nabble.com/Return-values-on-Stored-Procedure-tp6429881p25615942.html
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
