Home » SQL & PL/SQL » SQL & PL/SQL » UTL_FILE problem
UTL_FILE problem [message #259732] Thu, 16 August 2007 06:32 Go to next message
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 #259734 is a reply to message #259732] Thu, 16 August 2007 06:39 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Check this out.
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:125716900346699138

Regards

Raj
Re: UTL_FILE problem [message #259750 is a reply to message #259734] Thu, 16 August 2007 06:56 Go to previous messageGo to next message
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 #259778 is a reply to message #259732] Thu, 16 August 2007 08:26 Go to previous messageGo to next message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
Why use utl_file, why not use sqlPlus report and spool. See the following link

http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch6.htm#i1081008

[Updated on: Thu, 16 August 2007 08:26]

Report message to a moderator

Re: UTL_FILE problem [message #260027 is a reply to message #259778] Fri, 17 August 2007 03:27 Go to previous message
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
Previous Topic: Trigger Problem,Please help me out
Next Topic: PLS-00306: wrong number or types of arguments in call to 'CREATE_CHANGE_SET'
Goto Forum:
  


Current Time: Thu Dec 08 00:29:28 CST 2016

Total time taken to generate the page: 0.16246 seconds