By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,321 Members | 1,190 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,321 IT Pros & Developers. It's quick & easy.

PL/SQL: Printing questions

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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)
Jul 19 '05 #2

P: n/a
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
Jul 19 '05 #3

P: n/a
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)
Jul 19 '05 #4

P: n/a
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.

Jul 19 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.