Inser query error at receiver channel. Any advice plz ?

[Former Member]

Getting following error for INSERT statement at the receiver channel, no sure why its throwing error for SELECT keyword. just i am trying to insert a recored . Plz adivise .

4/28/09 7:59:46 PM 74b8e10f-3bcf-470a-3c1e-93e5bc174f03 Error processing request in sax parser: Error when executing statement for table/stored proc. 'EMPLOYEE' (structure 'STATEMENT'): java.sql.SQLException: ORA-00928: missing SELECT keyword

Line 1 / 25

[Former Member]

Access should be subelemeent of ROW in receiver st.

[Former Member]

Hi All,

Thanks for your response. I am using the following reciver structure, still unable to resolve the issue

<?xml version="1.0" encoding="ISO-8859-1"?>

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://XYZ.com/xi/projects/syngenta/n2" targetNamespace="http://ixyz.com/xi/projects/

/n2">

<xsd:complexType name="INF71270_DT_FILE_TO_DB_EMP_SYS">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

d4655c32348911de9edc0015c58913a2

</xsd:appinfo>

</xsd:annotation>

<xsd:sequence>

<xsd:element name="STATEMENT">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

efa866002b3711de9cae001e903f9370

</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="ROW">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

efa866012b3711de8d2f001e903f9370

</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="TABLE" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

efa866032b3711deb311001e903f9370

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

</xsd:sequence>

<xsd:attribute name="Action" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

80b322c02b3811deaaa6001e903f9370

</xsd:appinfo>

</xsd:annotation>

</xsd:attribute>

</xsd:complexType>

</xsd:element>

<xsd:element name="access" maxOccurs="unbounded">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

efa866042b3711dea93f001e903f9370

</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="Name" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

efa866052b3711de85a9001e903f9370

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="ID" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

efa866062b3711deb82a001e903f9370

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="Designation" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

efa866072b3711de80a0001e903f9370

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="City" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

efa866082b3711debe3a001e903f9370

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="DOB" type="xsd:date">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

efa866092b3711debc9d001e903f9370

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:schema>

[Former Member]

try to give "action" and "table" in small letters in your data type.

Thanks & Regards,

Purushotham

[Former Member]

Hi

Best way to debug

In u r JDBC Receiver --- Advance option

give

logSQLStatement true

When executed the scenario in RWB ---> Audit log u find the SQL statement

Copy that and execute that in u r SQL plus on u r DB.It will give u idea

problem seems with Data type structure

rgds

srini

[Former Member]

Hello Mohan,

First u need to check your JDBC Receiver structure.

STATEMENT NAME

TEXT (Subnode of STATEMENT)

ACTION(Subnode of TEXT) ATTRIBUTE Optional

TABLE(Subnode of TEXT) ELEMENT

ACESS(Subnode of TEXT) ELEMENT

Field1(Subnode of ACCESS)

Field2

Field3

.

.

.

"ACTION' must be Attribute. it is optional.

When ur going to "INSERT" or "UPDATE" We need check the parameters in JDBC Channel called QUERY STATEMENT

The SELECT Statment be SELECT * FROM XXX(TABLE NAME) WHERE NAME = 'MOHAN'

Check it for this way...

Regards,

Sateesh

Edited by: sateesh kumar .N on Apr 29, 2009 8:32 AM

[Former Member]

Please check your structure in the mapping.

Please share your structure that you are using in your mapping, so we can help you to solve error.

Thanks,

Hetal

[Former Member]

Hi...

Check if your receiver JDBC structure is correctly defined? If it is not defined correctly, it will show parser error.

Regards,

Leela