Support Questions
Find answers, ask questions, and share your expertise

PutSQL, Select query and CLOB

PutSQL, Select query and CLOB

Contributor

Hello All,

I want to run below query in PutSQL. This query is calling an Oracle function and accepts a CLOB value as parameter.

selectobds_loader.getmain(:clob)from dual

Does PutSQL support SELECT queries?

Can I pass a CLOB as attribute in NiFi? If Yes, then what would be the value for sql.args.n.type for CLOB?

Thanks in advance