Re: PL/SQL: Printing questions

george lewycky wrote:

> Daniel,
>
> If things went differently we would be using a product by Evergreen
> to do this, but without any money or resources and since my users
> arent satisfied with oracle's canned invoices we must resort to other
> methods,
>
> Discoverer is still an option but we require some customization
> and lookups and formatting that Discoverer wont handle.
>
> Right now I'm trying to use pre-printed forms and populate the
> needed areas with the data as a work around
>
> george
>
> Daniel Morgan <damorgan_at_exxesolutions.com> wrote in message news:<3F0060E9.58B8ACC_at_exxesolutions.com>...
> > george lewycky wrote:
> >
> > > 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
> >
> > No verison information so what you get will possibly be of limited usefulness.
> >
> > I'd use neither. Neither is a report writer and each of limited usefulness.
> >
> > Why not Oracle Reports? Discoverer? Seagate (Crystal), Cognos, Brio?
> >
> > Unless you are donating your time the cost of you writing this stuff manually
> > is a magnitude or more greater
> > than the cost of using the right tool for the job.

Then you have my sympathy. Well actually empathy. Been there ... done that. Yech!

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)