| UTL_FILE problem [message #259732] |
Thu, 16 August 2007 06:32  |
sajut
Messages: 69
Registered: January 2007
|
Member |
|
|
Dear All
I want to generate a report which has one full page of information per account and the output should be written into a .txt file. Thought I will use UTL_File of p/l sql. Everything works except the page skipping. Is there any way I can skip to a new page like \n for new line.
Thanks in advance
|
|
|
|
|
|
| Re: UTL_FILE problem [message #259750 is a reply to message #259734] |
Thu, 16 August 2007 06:56  |
sajut
Messages: 69
Registered: January 2007
|
Member |
|
|
Thanks Raj for the link and I could solve the problem
by declaring a constant with value chr(12) and print it using
utl_file.put_line(fhandler,f_feed);
Thank you very much
Saju
|
|
|
|
|
|
| Re: UTL_FILE problem [message #260027 is a reply to message #259778] |
Fri, 17 August 2007 03:27 |
sajut
Messages: 69
Registered: January 2007
|
Member |
|
|
|
My requirement is that, I need to print the customer details like , address, name, tel nos, contacts, credit polycies, yearly sales history etc, etc for a customer in a page., ie, one page per customer. That is how I found easy to use this that sqlplus reports
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
