PutSQL, Select query and CLOB

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

PutSQL, Select query and CLOB

mayank rathi
Hello All,

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

select *obds_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

NOTICE: This email message is for the sole use of the intended recipient(s)
and may contain confidential and privileged information. Any unauthorized
review, use, disclosure or distribution is prohibited. If you are not the
intended recipient, please contact the sender by reply email and destroy
all copies of the original message.