Skip to main content
LejlaKM
LejlaKM
Silver ⭐️⭐️⭐️
February 10, 2022
Question

Can I call oracle plsql procedure after my processor PutDatabaseRecord finished

Hi,

 

can someone help me to find solution for execute plsql oracle procedure after I finish putin record in my table in database. I have flow like this

LejlaKM_0-1644497154366.png

and when all job is done I have to execute procedure with max and min ID from this flow...

 

Thanks in advance

12 replies

steven-matison
Platinum ⭐️⭐️
steven-matison
Platinum ⭐️⭐️
February 10, 2022

@LejlaKM   Please check out this solution:

 

https://community.cloudera.com/t5/Support-Questions/Does-ExecuteSQL-processor-allow-to-execute-stored-procedure/m-p/285372/highlight/true#M211779

 

Found on this original thread:


https://community.cloudera.com/t5/Support-Questions/Does-ExecuteSQL-processor-allow-to-execute-stored-procedure/td-p/158922/page/2

 

Translate
    LejlaKM
    LejlaKMAuthor
    Silver ⭐️⭐️⭐️
    February 11, 2022

    Hi,

     

    I am new in nifi so I don't know how to create and pass parameter with max and min value of my ID in source table to plsql procedure... Please help. My whole flow now looks like this

     

    LejlaKM_3-1644567461396.png

     

     

    I add another processor like this with two parameters

    LejlaKM_0-1644567257501.png

    and I pass those parametres to proseccor like this

     

    LejlaKM_1-1644567371921.png

     

     

    then I get error 

    LejlaKM_2-1644567421065.png

     

    Thank you

    Translate
    steven-matison
    Platinum ⭐️⭐️
    steven-matison
    Platinum ⭐️⭐️
    February 11, 2022

    I would recommend do a test of the procedure without parameters by inserting test values directly to ensure it works.  This will do 2 things, first; confirm the procedure works, and second; indicate the issue with min/max is in the QueryRecord.  While testing flow, you should be able to see what the values of min/max are by inspecting the flowfile/attributes.

    Translate
    Terms & ConditionsAccessibility statement