Skip to Content
0
Former Member
May 20, 2010 at 04:13 PM

Calling store procedure using class cl_sql_statement not running

361 Views

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!