When I tried to execute below code it return error "ORA-06550 - PLS-00222: no function with name 'CONV_RATE_EXT_T' exists in this scope"
DECLARE
p_conv_rate_ext_tab irb_i134_conv_rate_pkg.conv_rate_ext_t := Irb_I134_Conv_Rate_Pkg.conv_rate_ext_t();
ret_code number;
error_code varchar2(1000);
BEGIN
p_conv_rate_ext_tab(1) := NEW irb_i134_conv_rate_pkg.conv_rate_ext_rec
( 'INR'
, 'USD'
, '2017-01-24T00:00:00.000+00:00'--TO_DATE(SYSDATE)
, '300000002289006'
, '0.01466'
, 'C'
, 'Inspire Daily Rate'
);
irb_i134_conv_rate_pkg.conversion_rate_extract(p_conv_rate_ext_tab,
ret_code,
error_code
);
dbms_output.put_line('p_ret_code - ' || ret_code);
dbms_output.put_line('error_code - ' || error_code);
END;
And below declaration is in package specifiction
TYPE conv_rate_ext_rec IS RECORD
(
from_currency VARCHAR2(1000),
to_currency VARCHAR2(1000),
conversion_date VARCHAR2(1000),
conversion_type VARCHAR2(1000),
conversion_rate VARCHAR2(1000),
status_code VARCHAR2(1000),
user_conversion_type VARCHAR2(1000)
);
TYPE conv_rate_ext_t IS
TABLE OF conv_rate_ext_rec INDEX BY PLS_INTEGER;
TYPE t_stg_tab IS
TABLE OF irb_i134_curr_conv_rates_stg%ROWTYPE INDEX BY PLS_INTEGER;
PROCEDURE conversion_rate_extract
(
p_conv_rate_ext_tab IN conv_rate_ext_t,
p_ret_code OUT NUMBER,
p_error_message OUT VARCHAR2
);