Call Store Procedure Oracle DB using cl_sql_statement

roberto_vacca2 — Tue, 25 Jul 2017 08:33:57 GMT

HI,

I've a question about calling a store procedure from ABAP returning a cursor Type.

Procedure is something like this:

    PROCEDURE dlanguage (p_rlist OUT cur)
    IS
    BEGIN
        OPEN p_rlist FOR
            SELECT ID, ISO, DES
              FROM dbch.DLANGUAGE END;
    END;

While I'm able to call a store procedure that returns simple parameters, I'm not able to call a store procedure giving a cursor back.

I've tried to use set_param_table method of CL_SQL_STATEMENT, passing a table pointer, but with not results.

CURSOR type in ABAP seems not working as type parameter.

The error is always:

con=1(XXXXXXXXXXXXXXX/XXXX): ORA-06550: line 1, column 7:#PLS-00306: wrong number or types of arguments in call to 'DLANGUAGE'#ORA-06550: line 1, column 7:#PL/SQL: Statement ignored

Could someone give me any tips about this?

Final Goal is to receive a structure with n fields of string type (undefined length) and it seems that probably we need to use Blob type in Oracle if is not possible to receive a data table back.

Thanks a lot!

topic Call Store Procedure Oracle DB using cl_sql_statement in Application Development and Automation Discussions

Call Store Procedure Oracle DB using cl_sql_statement