nifi-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mayank rathi <>
Subject PutSQL, Select query and CLOB
Date Mon, 04 Sep 2017 04:39:14 GMT
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.

View raw message