How to query a CLOB data using SQL in jira resources?

I have tried adding the below comments in the resources tab it's not working

select DBMS_LOB.substr(myColumn, 3000) from myTable
substr(colum,1,1000)


can someone help me here 

thanks in advance

1 answer

0 votes

Hi @John Christopher welcome to the community. Are you trying to setup a scriptrunner resource? Have you reviewed this page?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

It's all set up . I can able to query but my question is how to view the clob data.

when I try to view the CLOB column I get like this - oracle.sql.CLOB@814328b

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.