Skip to Content

Call Store Procedure Oracle DB using cl_sql_statement

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers