Inserting rows into an oracle table is giving Error.

Question

Hi All, I am getting the below error message while running the workflow. I am trying to delete and insert records into a table.The table is already created. Error: Output Data (2): Error running DELETE FROM ".": ORA-00942: table or view does not exist Can someone please help on this. Regards, Philip

MarqueeCrew · Accepted Answer

@pgeorge4,

I have a guess for you Phillip.  Again this is just a gUESS.  Oracle is vErY particular about CaPItalIzAtIOn.

Your Tablename is likely all CAPS in oracle.  Check your SQL to make sure that there is a match.

Cheers,

Mark