Hello together
i want to call a stored procedure that has an input and an output parameter but when i using my coding i m getting the following error
ORA-06550: line 1, column 7:#PLS-00201: identifier 'STORED_PROC_NAME' must be declared#ORA-06550: line 1, column 7:#PL/SQL: Statement ignored
GET REFERENCE OF lv_input IN lr_dref."in lr_cl_sql_statement->set_param( data_ref = lr_dref inout = cl_sql_statement=>C_PARAM_IN ). GET REFERENCE OF lv_out INTO lr_dref. "out lr_cl_sql_statement->set_param( data_ref = lr_dref inout = cl_sql_statement=>C_PARAM_OUT ). TRY. data lv_ROWS_PROCESSED type i. CALL METHOD LR_CL_SQL_STATEMENT->EXECUTE_PROCEDURE EXPORTING PROC_NAME ='Stored_Proc_Name' RECEIVING ROWS_PROCESSED = lv_ROWS_PROCESSED
-
i my oppinion there could be an error in setting the parameters. Has anyone an running solution for calling a stored procedure with in and out parameter. I already tested the ADBC Programs and even had a sight in the class documentation but there is no example with in and output parameter.
Thank your for your help!