cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-00913: too many values

Former Member
0 Kudos

Hi All,

I have developed a Inbound Interface (Proxy to JDBC interface).

I have mapped INSERT as a constant to the Action field in the JDBC structure.

while testing it is success in both the R/3 moni and XI moni.

when checked in Communication Channel Iam getting this error:

" Error processing request in sax parser: Error when executing statement for table/stored proc. 'LGC_IF_TR_05_081' (structure 'STATEMENT'): java.sql.SQLException: ORA-00913: too many values ".

Please suggest me.

Thanks,

Rahul.

Accepted Solutions (0)

Answers (1)

Answers (1)

vkaushik82
Active Participant
0 Kudos

check insert query it seems the number of value not matching in your statement.

Try to paste the query here which is formed

Edited by: Vikrant Kaushik on Dec 24, 2010 10:39 AM

Former Member
0 Kudos

Sender side (SAP):

- <REC>

<MOVEC>122</MOVEC>

<LIFNR>0001100</LIFNR>

<NAME1>BANOTO OTOMOTİV TİCARET A.Ş.</NAME1>

<MATNR>1560808900</MATNR>

<LFSNR />

<LFDAT>20101104</LFDAT>

<MENGE>8,000</MENGE>

<MEINS>ST</MEINS>

<DMBTR>4.91</DMBTR>

<WAERS1>TRY</WAERS1>

<NETWR>0.77</NETWR>

<WAERS2 />

<ZTERM>A014</ZTERM>

<LIFEX />

<VBELN />

<FKDAT />

</REC>

Target side (JDBC):

- <STATEMENT>

- <LGC_IF_TR_05_081 action="INSERT">

<table>LGC_IF_TR_05_081</table>

- <access>

<HAREKET_TURU>122</HAREKET_TURU>

<SATICI_KODU>0001100</SATICI_KODU>

<SATICI_ADI>BANOTO OTOMOTİV TİCARET A.Ş.</SATICI_ADI>

<RESIM_NO>1560808900</RESIM_NO>

<IRSALIYE_NO />

<IRSALIYE_TARIHI>20101104</IRSALIYE_TARIHI>

<MIKTAR>8,000</MIKTAR>

<BIRIM>ST</BIRIM>

<BIRIM_FIYAT>4.91</BIRIM_FIYAT>

<BIRIM_FIYAT_KURU>TRY</BIRIM_FIYAT_KURU>

<TOPLAM_TUTAR>0.77</TOPLAM_TUTAR>

<FATURA_KURU />

<VADE>A014</VADE>

<TOFAS_IRSALIYE_NO />

<TOFAS_FATURA_NO />

<TOFAS_FATURA_TARIHI />

</access>

</LGC_IF_TR_05_081>

</STATEMENT>

</ns0:MT_FILE_TG_05_081>

rajasekhar_reddy14
Active Contributor
0 Kudos

>

> Target side (JDBC):

>

> - <STATEMENT>

> - <LGC_IF_TR_05_081 action="INSERT">

> <table>LGC_IF_TR_05_081</table>

> - <access>

> <HAREKET_TURU>122</HAREKET_TURU>

> <SATICI_KODU>0001100</SATICI_KODU>

> <SATICI_ADI>BANOTO OTOMOTİV TİCARET A.Ş.</SATICI_ADI>

> <RESIM_NO>1560808900</RESIM_NO>

> <IRSALIYE_NO />

> <IRSALIYE_TARIHI>20101104</IRSALIYE_TARIHI>

> <MIKTAR>8,000</MIKTAR>

> <BIRIM>ST</BIRIM>

> <BIRIM_FIYAT>4.91</BIRIM_FIYAT>

> <BIRIM_FIYAT_KURU>TRY</BIRIM_FIYAT_KURU>

> <TOPLAM_TUTAR>0.77</TOPLAM_TUTAR>

> <FATURA_KURU />

> <VADE>A014</VADE>

> <TOFAS_IRSALIYE_NO />

> <TOFAS_FATURA_NO />

> <TOFAS_FATURA_TARIHI />

> </access>

> </LGC_IF_TR_05_081>

> </STATEMENT>

> </ns0:MT_FILE_TG_05_081>

Why LGC_IF_TR_05_081 coming two times, becaus eof this you getting error, if you want insert multiple records based on occurance of source, you have to may the occurace of source node to access and change occurace of access to 1 to unbouded.

Regards,

Raj

former_member200962
Active Contributor
0 Kudos
" Error processing request in sax parser: Error when executing statement for table/stored proc. 'LGC_IF_TR_05_081' 
(structure 'STATEMENT'): java.sql.SQLException: ORA-00913: too many values ".

1) Is LGC_IF_TR_05_081 name of your DB table?

Are you sure that your DB table has these many columns:

<access>

<HAREKET_TURU>122</HAREKET_TURU>

<SATICI_KODU>0001100</SATICI_KODU>

<SATICI_ADI>BANOTO OTOMOTİV TİCARET A.Ş.</SATICI_ADI>

<RESIM_NO>1560808900</RESIM_NO>

<IRSALIYE_NO />

<IRSALIYE_TARIHI>20101104</IRSALIYE_TARIHI>

<MIKTAR>8,000</MIKTAR>

<BIRIM>ST</BIRIM>

<BIRIM_FIYAT>4.91</BIRIM_FIYAT>

<BIRIM_FIYAT_KURU>TRY</BIRIM_FIYAT_KURU>

<TOPLAM_TUTAR>0.77</TOPLAM_TUTAR>

<FATURA_KURU />

<VADE>A014</VADE>

<TOFAS_IRSALIYE_NO />

<TOFAS_FATURA_NO />

<TOFAS_FATURA_TARIHI />

</access>

Confirm the DB table structure and then make an INSERT accordingly.

Regards,

Abhishek.

Former Member
0 Kudos

Thank you, Abhishek.