This content has been marked as final. Show 3 replies
I believe Q_1 returns only one column CUSTOMER_TRX_ID.
You can try having an alias for the column like
select XX_PACKAGE_PKG.Header_Data (:p_invoice_num_from, :p_invoice_num_to, :p_invoice_date_from, :p_invoice_date_to, :p_customer_name) CUSTOMER_TRX_ID
Q_1 returns more than one column.
I resolved this problem.
I had element name "customer_trx_id" also in Q_2 and this rewrite me customer_trx_id from Q_1.