Why is my procecure producing null xml output
Hi gurus,
I have written a procedure to pull relevant ar transaction data in order to be able to produce output for a voucher. (Something similar to an invoice but different!). I need the xml in order to build my rtf which in turn will be attached to the template in xml publisher.
The results I get looks like this.
This is my procedure:
CREATE OR REPLACE PROCEDURE APPS.XXCDCCCTVOUCHER (errbuf VARCHAR2, retcode NUMBER, p_from_trx_number IN VARCHAR, p_to_trx_number IN VARCHAR)
AS
/Cursor to fetch Voucher details/
CURSOR xml_cctvoucher
IS
select hp.party_name customer_name,rcta.trx_number,