Question Re: How to input Internal Table as a Parameter for execut... in Technology Q&A

How to input Internal Table as a Parameter for execute Procedure from Oracle Database

nadirelc — Fri, 14 Jun 2024 04:38:19 GMT

Here is my code look like

exec sql

execute procedure scheme.package.my_procedure (
            IN :lv_a,
            IN :itab_a,
            IN :itab_b,
            INOUT :lv_c,
            OUT :lv_d
            )

endexec.
I got the error 'The DSQL interface was called with invalid parameters.' I assume this error came from the internal table that is not recognized by Oracle database, meanwhile in the Oracle database itab_a and itab_b are PL/SQL Table.

Can anyone please help me, how to execute oracle database procedure that has PL/SQL TAble parameter from SAP ABAP

Re: How to input Internal Table as a Parameter for execut...

Romanos — Fri, 14 Jun 2024 09:02:09 GMT

Hello @nadirelc ,

Have you tried to specify the secondary connection to Oracle DB before executing the procedure?

DATA(conn) = CONV dbcon-con_name( `...` ). EXEC SQL. CONNECT TO :conn ENDEXEC. EXEC SQL. EXECUTE PROCEDURE... ENDEXEC.

Re: How to input Internal Table as a Parameter for execut...

nadirelc — Wed, 19 Jun 2024 02:17:56 GMT

i already used that in first, the connection to oracle database is works well, only the procedure tabular parameter is the problem

Re: How to input Internal Table as a Parameter for execut...

Romanos — Wed, 19 Jun 2024 07:23:20 GMT

Hello @nadirelc ,

The causes regarding the internal tables, that i can think are :
1. The internal tables are hashed or sorted or contain secondary keys. The itabs should be standard without secondary keys

2. Incorrect type mapping from ABAP itab to Oracle array.

3. Incorrect column name mapping from ABAP itab to Oracle array. In abap column names contain only capital letters whereas in oracle can contain lowercase letters.