Forum Discussion

shubhimu's avatar
shubhimu
Contributor
6 years ago
Solved

Ready APi Not able to run procedure with clob output type parameter in it

Hi,  I am able to connect to db using groovy but when i am trying to run procedure using groovy then its coming in the catch block. It has 2 input and 3(1 as CLOB type, 1 as Integer, 1 as Varchar) ...
Scripting
richie's avatar
richie
Community Hero
6 years ago
Hey shubhimu

I dont know whether i can help but i'll try cos it doesnt look like anyone has any ideas on this.

Firstly...this is sqlserver not oracle right? (cos sqlserver doesn't have a clob datatype and i havent seen try/catch in oracle before)

Secondly you need to specify the type of the column for the clob type, right? So if sql server doesnt have clob type, but clob type data is instead stored in either NVARCHAR(max) or VARCHAR(max), rather than sql.VARCHAR, have you tried sql.VARCHAR(max) in your sql?

Thirdly....you said you're trying to execute the proc via groovy.....have you tried running the proc via a JDBC step instead?

That's all the ideas i have im afraid!

Nice one,

Rich