Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Write data in-DB Vs Output Data tool (Oracle)

Xeu911
8 - Asteroid

Hi,

 

I have an issue within a workflow when trying to update / create a table in Oracle.

 

Context : Everything is done using In-DB tools in the workflow. The issue happens when I'm trying to update an existing DB, or creating a new one. As soon as I use the "Write data in-DB" tool, I get an error message "ORA-00933 sql command not properly ended". 

However, using the "Output Data tool" in Memory I don't have any issue (either to update or create the table).

 

I cannot share the workflow since it contains client's data, but I would really appreciate if someone could give me a hint on this one!

 

Thanks,

Clément

1 REPLY 1
apathetichell
20 - Arcturus

turn on logs in your odbc connection - compare logs. send to alteryx support. This sounds like a bug.

Labels
Top Solution Authors