Get CLOB from JDBC Request Callable Statement

[Ryabtsev Vladimir <v....@pflb.ru>]

Hi,

I'm calling stored procedure (Oracle) using JDBC Request in Callable Statement mode and I need to access output parameter of this procedure which is of CLOB type. 

In simple Select statement I can define name of the special object ('Result variable name') which I can use to access the result set, including BLOB, CLOB, etc. But in case of Callable Statement mode JDBC Sampler does not define that object and does not put it into vars. At the same time I can't use OUT CLOB variable as it filled with something like 'java.sql.CLOB...' instead of real value.

How can I get value of the CLOB output parameter as String or Jmeter variable?

--
Vladimir Ryabtsev

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
For additional commands, e-mail: user-help@jmeter.apache.org

Re: Get CLOB from JDBC Request Callable Statement

[Deepak Shetty <sh...@gmail.com>]

Hi
CLOB data is not supported by the current sampler as far as I remember -
you need to write your own code (either extend the sampler or just create a
java sampler that makes a JDBC call)


On Fri, Mar 21, 2014 at 7:17 AM, Ryabtsev Vladimir <v....@pflb.ru>wrote:

> Hi,
>
> I'm calling stored procedure (Oracle) using JDBC Request in Callable
> Statement mode and I need to access output parameter of this procedure
> which is of CLOB type.
>
> In simple Select statement I can define name of the special object
> ('Result variable name') which I can use to access the result set,
> including BLOB, CLOB, etc. But in case of Callable Statement mode JDBC
> Sampler does not define that object and does not put it into vars. At the
> same time I can't use OUT CLOB variable as it filled with something like
> 'java.sql.CLOB...' instead of real value.
>
> How can I get value of the CLOB output parameter as String or Jmeter
> variable?
>
> --
> Vladimir Ryabtsev
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> For additional commands, e-mail: user-help@jmeter.apache.org
>
>