Getting error while executing simple SQL select query

[rupali2.deshmukh]

I’m getting the below error while executing the DB query, the connection was successful but while executing the query I’m getting the error.

For E.g. - Select * From empmaker_ar_head Where sys_ar_no =‘802004400045’
The same query working fine in DB, hardly it will result 20-25 records.

The same query when I executed from Oracle SQL developer its working fine.

Error - A value of type ‘System.DBNull’ cannot be set to the location with name ‘out’ because it is a location of type ‘System.String’.

1. Environment details
   

2. Activity packages versions

3. Full error message -

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’.

[rupali2.deshmukh]

@ Maciej Kuzmicz- Could you help here to sort out the issue.

[alexandru (Alexandru Roman)]

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.

[rupali2.deshmukh]

Yes, issue is resolved.
Thanks.