I'm Getting "System.DBnull" error while excuting Select query after connecting Oracle DB fromo uipath

" Execute Query: A value of type ‘System.DBNull’ cannot be set to the location with name ‘out’ because it is a location of type ‘System.String’."
Above is the error i’m getting while i was pulling only one column which contains 5 rows without null value.


Can you please check whether same query is working fine in Oracle DB ?

yes it is working in oracle db.


May I know what version of Database package version are you using here ? Try to downgrade the package version to previous version and then check once.

Hi @yash_p ,

Could you let us know if the Select Query was working fine Previously or When First Used itself you get this Error ?(In UiPath)

This might be a Bug, Since there are other posts recently related to the same Error. But it is not confirmed yet. Maybe because in both cases Oracle DB is being used.

currently version 1.5.0 i’m using


Downgrade the package version to 1.4.0 and then check once.

Can you try with the latest Database.Activities v1.6.1 as we have a potential fix for this issue. Please let me know if this works for you.

i Have declared extra parameter in execute qurry action because of that error was genrated

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.