Home » SQL & PL/SQL » Client Tools » text output from iSQL*PLUS (DB: Oracle9i,,RHEL 2.1 AS)
text output from iSQL*PLUS [message #399392] Wed, 22 April 2009 00:17 Go to next message
Messages: 237
Registered: June 2006
Location: India, Ahmedabad
Senior Member
Dear Friends

We are using iSQL*PLUS as a small query base reporting tool.we have created html files and call this html files through web browser.user give the required parameter and that html file call the stored sql file from server. user get the output on screen in html format.My main problem is i want this output in .txt file,stored somewhere on server.spool is not supported in iSQL*PLUS.Sample of html and sql file will be attached if required.


Re: text output from iSQL*PLUS [message #399499 is a reply to message #399392] Wed, 22 April 2009 08:54 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
To the best of my knowledge, the only way you'd get the output onto the server would be by writing a stored procedure and using UTL_FILE.
Previous Topic: ORA-01460: unimplemented or unreasonable conversion requested
Next Topic: SQLPLUS: can substitution variable &1 have a default?
Goto Forum:

Current Time: Fri Jul 21 09:52:45 CDT 2017

Total time taken to generate the page: 0.13084 seconds