Forum Discussion
richie
5 years agoCommunity Hero
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
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
- shubhimu5 years agoContributorThanks for your reply.
The database I am using is oracle and the way you mentioned is not working for me because my db is not sql I guess that's the reason- richie5 years agoCommunity HeroWhat version of oracle?
I would expect you to be able to specify the clob type if oracle....
Ta
Rich- sonya_m5 years agoSmartBear Alumni (Retired)
Thank you for your efforts Richie! Appreciated!
shubhimu were you able to solve this? If not, let's try to continue the investigation here. Looks like Richie might have an idea about what is going on, they just need more info from you.
You can try raising a support ticket here.