Inserting rows into an oracle table is giving Error.

[pgeorge4]

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 "<schema>.<Tablename>": ORA-00942: table or view does not exist

Can someone please help on this.

Regards,
Philip

[MarqueeCrew · Accepted solution]

@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

[pgeorge4]

Thanks Mark.

It is working now after I used caps.

Regards,

Philip