When Trying to make an INSERT or UPDATE in Oracle, nothing is inserted into database


#1

I’m trying to make an INSERT Query within my Oracle database and have redash configured to use cx_Oracle v5.2 as well as set up the necessary library paths and other variables. However, when I run this query, nothing gets inserted into the database and I get the error: Error Running Query : Query completed but it returned no data. My process has been inserted below, would love to know if anyone else has had trouble with this issue and resolved it or if this is a bug I should submit for future fixes with how the redash oracle query runner works. My user for oracle has read and write permission so it isn’t a matter of not being able to insert, but maybe has to do with how the cx_Oracle module is trying to integrate with the redash python script. Thanks for your help!


#2

I have the same problem with mysql update


#3

https://redash.io/help/troubleshooting/query_complete_no_data.html