FATAL ERROR document format: structure 'table Name', no key element found in PI

[Former Member]

Hello Team,

Good Day...

When am trying to send the request from PI to Oracle(Syn), am gettin g the below error.

java.sql.SQLException: FATAL ERROR document format: structure 'table name', no key element found.

As am using only "SELECT" statement in action. Below are the target structure which i used.

capture.png

sender-structure.png

Can you please check and help me here.

Regards,

VB

[Former Member]

Hello mark,

This is syn scenario, and we are using the select statement.

Is it possible to get the response from db using select statement?

please help here how to do it..

Thanks in Advance...

Regards,

VB.

[markangelo_dihiansan]

Hi,

Use SQL_QUERY instead

https://help.sap.com/saphelp_nwpi711/helpdata/en/44/7b7855fde93673e10000000a114a6b/content.htm

Regards,

Mark