PL/SQL: Printing questions

[george lewycky]

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

[Daniel Morgan]

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.
--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
da******@x.washington.edu
(replace 'x' with a 'u' to reply)

[Greg Forestieri]

ge*****@nyct.com (george lewycky) wrote in message news:<68**************************@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

[Daniel Morgan]

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 <da******@exxesolutions.com> wrote in message news:<3F**************@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/e...ad/oad_crs.asp
da******@x.washington.edu
(replace 'x' with a 'u' to reply)

[Alex Filonov]

ge*****@nyct.com (george lewycky) wrote in message news:<68**************************@posting.google. com>...

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

George,

Usually you use Oracle Reports with Oracle Apps. It's easy, all
"canned" reports in Apps are written used Reports, you can customize
them without big problems. What's the problem with Reports on your
installation?


Daniel Morgan <da******@exxesolutions.com> wrote in message news:<3F**************@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.