Home » Developer & Programmer » Forms » print form
print form [message #86966] Wed, 24 November 2004 05:17 Go to next message
hudo
Messages: 159
Registered: May 2004
Senior Member
Hello,

How can I form be printed ?
What is an appropiate way to print from withinn forms ?
Re: print form [message #86990 is a reply to message #86966] Fri, 26 November 2004 14:04 Go to previous messageGo to next message
Hi!
Messages: 9
Registered: November 2004
Junior Member
you could press the PRINT button but I guess thats not want you call helpful :)

Are you using web forms or client-server..? (it may make a difference)

Export data:
Create a file UTL_FILE or TEXT_IO (latter pre 9i(?))

OLE2 - export to word or excel
Client-Server works find is quite simple
Web forms very slow, suggest export data first

create a report:
use Oracle Reports or similar tool, although often only good for printing.
Re: print form [message #86995 is a reply to message #86990] Sat, 27 November 2004 01:57 Go to previous messageGo to next message
hudo
Messages: 159
Registered: May 2004
Senior Member
Hello,
TEXT_IO sounds good. Where can I find it (Oracle DB 8 / Oracle DB 9) ??

Maybe someone has a simple example ?
As far as I know TEXT_IO writes on the local machine (client). This would be sufficient.
OLE2 would be also ok, but I do not know how, a little example would be a great help. Is the webutil package necessary for OLE2 ??

Thanks for the suggestions
Re: print form [message #87001 is a reply to message #86995] Sun, 28 November 2004 08:09 Go to previous messageGo to next message
Hi!
Messages: 9
Registered: November 2004
Junior Member
Test_io was removed in later version of oracle

declare
val text_io.file_type; --to_test text_io
--val utl_file.file_type; --to test utl_file
begin
null;
end;

runnig this will let you know - if it errors you don't have it! :)

WEB_UTIL will be needed for OLE2 if you are using web-forms, but not for client-server? which are you using?
Re: print form [message #87005 is a reply to message #87001] Sun, 28 November 2004 11:48 Go to previous messageGo to next message
hudo
Messages: 159
Registered: May 2004
Senior Member
Hello Hi!

I'm using Forms 10g with the Application Server 10 and (at the moment) Oracle Database 8.1.7.2 (for production)
and Database 9 during development (later version 9 should alos be used for production).
Ok, with your test I get errors with TEXT_IO so I don't have it. Exists the possibility to add the package TEXT_IO as stand-alone with newer database versions ?
Re: print form [message #87295 is a reply to message #87005] Thu, 16 December 2004 11:27 Go to previous messageGo to next message
Just John
Messages: 69
Registered: November 2004
Member
TEXT_IO is not availiabel in 10g (unsure 9i)
Re: print form [message #289090 is a reply to message #87295] Wed, 19 December 2007 10:46 Go to previous messageGo to next message
Nilesh.varshney
Messages: 1
Registered: December 2007
Junior Member
TEXT_IO is come with Oracle forms. Check with Forms It will be there

Re: print form [message #289174 is a reply to message #289090] Wed, 19 December 2007 23:39 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
You can also use utl_file.

David
Previous Topic: Problem with Create Trigger
Next Topic: Running JSP Excel report from Forms 10g
Goto Forum:
  


Current Time: Sat Dec 03 12:22:23 CST 2016

Total time taken to generate the page: 0.12611 seconds