XI: RFC <--> JDBC communication deep structure

[former_member301120]

Hello to all!

I've got a RFC <--> JDBC szenario. Insert an update statements work fine.

Now I want to implement a "SELECT"-statement. Therefore the XML-SQL-statements needs a <key>-tags such as:

<key>

<col1>value</col1>

<col2>value</col2>

</key>

<key>

<col2>value</col2>

</key>

To represent the key structure in ABAP I did the following steps

- I created a structure "keyvalue" with fields: column, value (for <col>value</col>),

- a table type "andkey" with line type "keyvalue",

- another table type "orkey" with linetype "andkey"

I use the table type "orkey" as exporting parameter for the element "selectkey" in my rfc funtion module :

CALL FUNCTION 'FUBA_JDBC' DESTINATION 'XI'

EXPORTING

selectkey = it_key

TABLES

outtab = it_outtab

• RESPONSE =

My problem is now, that the rfc function module creates a shortdump: CALL_FUNCTION_OPEN_ERROR

Does anybody know a solution? Could I use the table type "orkey" in the rfc?

Thanks for your suggestions,

Christian

[ravi_raman2 · Accepted solution]

Christian,

This should probably be posted in the abap forum, you can get some help there.

Regards

Ravi Raman