Are there any information available regarding CL_SQL_STATEMENT?

[Former Member]

We have a task to execute a stored procedure in Oracle from a BSP page. And this procedure has out parameters. I was trying to do this with the following code:

l_stmt->set_param( data_ref = lr_param
           inout = cl_sql_statement=>c_param_out ).

But with no success. Oracle says just:

ORA-06572: Function xxxxxx has out arguments

Are there any working examples of using stored procedures in CL_SQL_STATEMENT with out params? Any other docs regarding this class would be very helpful.

Thanks in advance.

[Former Member]

Found that OUT parameters work only with EXECUTE_PROCEDURE and do not work with other variants (e.g EXECUTE_QUERY)

[Former Member]

Found ADBC_DEMO programm but there is no out parameters