Hello
I am trying to access the table type in cursor getting the error,
SELECT
sot.included_tax_amount,
sot.payment_section_code,
sot.payee_decision_reason,
sot.original_payee_code,
sot.description,
sot.remarks,
sot.expenses_bearing_section_code,
sot.input_output_by_code,
sot.in_charge_code
FROM TABLE(sal_oif_tbl) sot
WHERE (sot.registration_month = gcv_con_03 OR sot.registration_month = gcv_con_3)
AND sot.input_type IN (gcn_con_5,gcn_con_6,gcn_con_7,gcn_con_8)
AND (sot.credit_voucher_appln_type = gcv_single_space
OR sot.credit_voucher_appln_type IS NULL);
cursor get_sal_oif_cur
is select
sof.attribute2,
sof.attribute3,
sof.attribute4,
sof.attribute5,
sof.attribute6,
sof.attribute7,
sof.attribute8,
sof.attribute9,
sof.attribute10,
sof.attribute11,
sof.attribute12,
sof.attribute13,
sof.attribute14,
sof.attribute15
FROM xxhjr_sales_condition_oif sof;
--Type declaration for get_sal_oif_cur
TYPE sal_cond_oif_tabtyp IS TABLE OF
get_sal_oif_cur%ROWTYPE INDEX BY BINARY_INTEGER;
--Table type declaration for get_sal_oif_cur
sal_oif_tbl sal_cond_oif_tabtyp;
I am not sure why that error is coming?
we cannot use it table type in cursor can you please help me....
Help is really appreciated
Thanks in advance