Skip to Content
0
Sep 22, 2014 at 07:24 AM

ORA-00942: table or view does not exist

400 Views

Hi experts,

Please please help me out of this,

I have Proxy --->> Oracle table Scenario

When i check in my CC i m getting the following error.

Unable to execute statement for table or stored procedure. 'MYTABLE' (Structure 'Statement') due to java.sql.SQLException: ORA-00942: table or view does not exist

This is the payload in SXMB_MONI :-

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:PaymentDataDB xmlns:ns0="urnmynamesapce">

- <Statement>

- <dbTableName action="INSERT">

<table>MYTABLE</table>

- <access>

<PAYID>dsadsd</PAYID>

<MEMONBR>fsdfsd</MEMONBR>

<ISSUEDT>02-02-14</ISSUEDT>

<AMT>fsdfsdf</AMT>

<CRCY>sdfsdf</CRCY>

</access>

</dbTableName>

</Statement>

</ns0:PaymentDataDB>

And i'm sure i have entered the correct credintials on recevier JDBC channel.

Please help me on this.

Thanks,

Manoj K