Hi,

I am getting error Ora-08103: Object No longer exists when select query uses type object in a procedure.

below the code used for select query

procedure upp_rate is

l_typ_detail_list typ_detail_list;

begin

select typ_oc_sec_detail(
sec_sid,
fed_open_rate,
eql_avg_rate_5,
eql_avg_rate_all,
ast_loan_rate_avg,
src_date,
null,
null,
shortcode,
cusip,
bbg_ticker,
sedol,
isin,
security_type,
dtc_eligible_derived,
country_of_quotation,
dtc_do_chill_ind,
settlement_agency )
bulk collect into l_typ_detail_list
from vw_details
;


type typ_detail_list as table of typ_detail ;

typ_detail object defined at oracle database.


Please can you help me in finding out why would the select queries throw Ora:08103 error and resolution for the same.


Thanks,
Raja