Skip to Content
0
Former Member
Oct 24, 2005 at 02:39 PM

Are there any information available regarding CL_SQL_STATEMENT?

55 Views

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.