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.