Skip to Content
0

Call Store Procedure Oracle DB using cl_sql_statement

Jul 25, 2017 at 08:33 AM

35

avatar image

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!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers