Skip to content
TheChatArchiveThe Chat Archive
gpt-3.5-turbo-0301· OpenAIAi2 WildChat-4.8M (AI2)

ORA-06550: line 15, column 3: PLS-00306: wrong number or types of arguments in call to…

  1. User

    ORA-06550: line 15, column 3: PLS-00306: wrong number or types of arguments in call to 'GET_RP_CONSTRUCTOR_HISTORY' ORA-06550: line 15, column 3: PL/SQL: Statement ignored

    declare subs_id subscribers.subs_id%TYPE := 1699586; --– ip_subs_id row_first NUMBER := 1; --ip_row_first row_last NUMBER := 20; -- ip_row_last num_change SBMS_RP_CONSTRUCTOR_AQF_USR_TEST.NAME10_ARRAY; -- oa_num_change name_template SBMS_RP_CONSTRUCTOR_AQF_USR_TEST.NAME255_ARRAY; -- oa_name_template start_date SBMS_RP_CONSTRUCTOR_AQF_USR_TEST.DATE_ARRAY; -- oa_start_date end_date SBMS_RP_CONSTRUCTOR_AQF_USR_TEST.DATE_ARRAY; -- oa_end_date user_method SBMS_RP_CONSTRUCTOR_AQF_USR_TEST.NAME50_ARRAY; -- oa_user_method date_operation SBMS_RP_CONSTRUCTOR_AQF_USR_TEST.DATE_ARRAY; -- oa_date_operation sum_AP SBMS_RP_CONSTRUCTOR_AQF_USR_TEST.NUM10_ARRAY; --oa_sum_AP total NUMBER; -- op_total

    BEGIN bis.SBMS_RP_CONSTRUCTOR_AQF_USR_TEST.GET_RP_CONSTRUCTOR_HISTORY( ip_subs_id => subs_id, ip_row_first => row_first, ip_row_last => row_last, oa_num_change => num_change, oa_name_template => name_template, oa_start_date => start_date, oa_end_date => end_date, oa_user_method => user_method, oa_date_operation => date_operation, oa_sum_AP => sum_AP, op_total => total); END;

  2. Assistant

    This code declares variables and attempts to call a PL/SQL procedure named GET_RP_CONSTRUCTOR_HISTORY in the package SBMS_RP_CONSTRUCTOR_AQF_USR_TEST. However, the error message indicates that there is a problem with the arguments being passed to the procedure. It is likely that the procedure expects different data types or a different number of arguments than what is being provided. The exact problem needs to be investigated and resolved before the code can be successfully executed.