Re: PL/SQL: Printing questions

gelewyc_at_nyct.com (george lewycky) wrote in message news:<68aecc05.0306300723.502b31a6_at_posting.google.com>...
> I have Oracle Apps ( AR & GL) and I working on creating our own
> Invoice but I'm unsure about certain aspects of PL/SQL & Printing.
>
> I have some PL/SQL working with the invoice data from AR_INVOICE_HEADER_V
> table already.
>
> 1. DBMS_OUTPUT vs. TEXT_IO
> What advantages exist for the two ?
>
> 2. Page breaking ??
> How can a perform a page break other than setting the lines per page?
> I will have situations where page breaks will occur before I reach
> the page break point
>
> 3. Is there a TAB feature?
> I need some method to position the text in a way other than
> using the space bar.
>
>
> Thank you very much
>
> George Lewycky

Whoa! If your customer doesn't like Oracle's canned invoice they'll like this less.

Grab a copy of the canned invoice. It's an extremely complex Oracle Reports report (rdf) and will require some careful work. Modify it to meet the customer need then install as a custom report. Bear in mind Oracle will laugh in your face if you call for support on this.

There is no way easier to do this, and in fact if you merely "print" reports out without the behind-the-scenes table work that goes on you'll just be automating the slow destruction of your invoicing tables.

Good luck
Greg Received on Tue Jul 01 2003 - 12:07:33 CDT