Errorwhile inserting extracted information in table in oracle database

Help Studio
, , , , , , ,
1

Dear All,

I will be grateful if someone can help me o solving the error i am facing while extracting the information from documents using documents understanding … so i am storing the data in oracle database and after successfully creating connection with database , i get error while inserting the data in the table… I was not getting error when i used similar kind of workflow and activities

The image shows a detailed workflow diagram from an automation tool, illustrating steps for data extraction, export, merging, and processing of data tables. (Captioned by AI)
The image shows a detailed workflow diagram from an automation tool, illustrating steps for data extraction, export, merging, and processing of data tables. (Captioned by AI)1214×857 45.2 KB

2
21225×886 41.1 KB

1
11569×889 66.1 KB

in the past . Here is the attached screenshot for reference and the entire workflow picture .

2

@Rahul_Karn

please open exception from locals panel…which might have more info

also is the datatable empty?

looks like it might be

cheers

3

Dear Anil,

Thank you for your repsonse. Yes I am new to UiPath .I put a log message details and it shows system.datarow.collection from dtOutput

but i am not sure if values are getting populated in that . I am attaching the screenshot from Locals panel also. It would really be grateful if you could see once and suggest me what is going wrong in the workflow.

The image displays a screenshot of a UiPath workflow in debugging mode, showing variables, activities, and an "ORA-00936: missing expression" error in the Output panel. (Captioned by AI)
The image displays a screenshot of a UiPath workflow in debugging mode, showing variables, activities, and an "ORA-00936: missing expression" error in the Output panel. (Captioned by AI)1537×894 57.3 KB

4

@Rahul_Karn

Open this

image

cheers

5

Just to make sure, Can you verify the number of columns you are trying to insert and the no of columns with respective properties of the table before you try to insert it. Sometime it fails to insert information when because of Columns miss match or sometimes some of the columns in Table wouldnt accept duplicates/nulls but UiPath might try to pass them so we could face an error.