Created 04-06-2016 12:02 PM
Can I execute stored procedure on database using ExecuteSQL proessor ? Is there any sample ?
Created 04-06-2016 12:16 PM
I don't think so but maybe you can wrap the exec storedprocedure into a shell script or groovy and run it in ExecuteProcess/ExecuteScript?
Created 02-11-2022 05:17 AM
Hi,
I have two separate flow files (one for insert and one for delete) which works fine. And in the end i put Output port.
After that job is done I need to execute plsql procedure from destination database., so I made another process group with input port and another flow
Processor generate table fetch selecting max and min date from one table like this
And after that I need those two values to pass to plsql procedure and I don't know how.
Last processor putsql look like this
and when I have no parameter to pass all works fine, but I need those parameter to pas
I hope that you can help me with this. I am new in nifi as you can see
Created 02-14-2022 04:44 AM
You need to use some processor to extract the info of the flowfile. For example, you can use ExtractText processor after generated table fetch proccesors. The result of this (ExtractText) processor is the atribute you need to use next (max and min) but depend how you configure you will have the same flowfile or not. This is important to the flow in the next steps (if you need to use again).
You can find information of ExtractText processor here ExtractText processor
And this is te documentation web page of nifi.
Sorry for my english.
Created 06-21-2022 03:55 AM
Hi Can tell me what is package and body
Created 06-21-2022 07:02 AM
Hi..
You can find more information here