Facing -Insert: Dynamic SQL generation is not supported against a SelectCommand that does not return any base table information

Help Activities
, ,
1

I am getting this error while inserting data table into oracle database and error is attached below ref. Can you please let me know what is the extract root cause of error ?

Below are the possible analysis i have tried
1.Verified column names in data table & database both are matching .
2.Verified ODBC drivers its correct and able to connect database manually
3.Version compatibility also matching .

Error:
System.InvalidOperationException: Dynamic SQL generation is not supported against a SelectCommand that does not return any base table information. at UiPath.Database.Activities.InsertDataTable.HandleException(Exception ex, Boolean continueOnError)
at UiPath.Database.Activities.InsertDataTable.ExecuteAsync(AsyncCodeActivityContext context, CancellationToken cancellationToken)
at UiPath.Database.Activities.AsyncTaskCodeActivity.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)

image
image1830×357 19.4 KB

2

@nabisab.18

May I know which activity you are using?

cheers

3

I am using database Insert activity to insert data table into oracle database