This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I run a workflow with Write Data In-DB tool configured with Output Mode "Append Existing" and I get "Error: ORA-00942: table or view does not exist" or "ORA-00903 - invalid table name" even though the Oracle table exists. Why?
Error: Write Data In-DB (2): DataWrapOCI: Unable to prepare the query: "SELECT * FROM "sysdate_table"" Error: ORA-00942: table or view does not exist
Incorrect Quote Identifier for the database specified in the In-DB connection tool.
Make sure the In-DB connection is configured to both read and write 'Quoted'.