Hello, Could someone please help me with this case I want to copy data from an Oracle table to another table that has the same schema. I want to count number of record read in and number of records succesfully inserted to the target, and put those counts into a tracking table. My idea is as below In which, the left branch I count the records in, the right branch I insert data to target table and then count records. -QueryRecord: count number of record. Output from left and right branch are the same and as below -ExtractText: to extract just the count to record_in and record_out. The output attribute is as below -MergeContent: Merge these 2 attributes before put SQL. Result and output attributes are as below   -UpdateAttribute: to escape user-based input My query is something like: INSERT INTO TABLE_1 (TABLE_NAME, RECORD_IN, RECORD_OUT) VALUES ('manually_input', ?, ?) I got the error: ORA-00911: invalid character SQL = INSERT INTO TABLE_1 (TABLE_NAME, RECORD_IN, RECORD_OUT) VALUES ('manually_input', :1, :2) How could I fix this error? Also is this a proper approach or would you suggest another way to perform this task? Thank you so much ... View more

Hi all, I'm a newbie. I want to read a local .csv file that contains only an ID column, then use that list of ID in a dynamic query to get data from an oracle table. My flow is as below: I configure processors as following: +ReplaceText(1): is to replace "\n" with "," + ReplaceText(2): Remove the last empty row + ExtractText: assign ID list to attribute named list_id +UpdateAttribute: to specify name and value of property. The list contains 10 ID + ExecuteSQL: There is no task In for UpdateAttribute, the flow stop at ExtractText, the detail tab in view data governance is below, it said File.Size is 0 bytes.  However it doesn't return any error so I don't know where to fix. Could you please help. Thank you   ... View more

Hello, I want to copy record from one table to another table that has the same structure in Oracle 12c+. One not-null column in source has white space. When trying to insert record to the target table, I got error "cannot insert NULL", so I added UpdateRecord processor to replace Null with white space, but still have the same error. It works if I replace Null with any other character like "_". Is there any way to keep white space when inserting to the target table? Below is my Flowfile and the UpdateRecord properties. Thank you   ... View more