Home » Other » Client Tools » text output from iSQL*PLUS (DB: Oracle9i,9.2.0.1.0,RHEL 2.1 AS)
text output from iSQL*PLUS [message #399392] Wed, 22 April 2009 00:17 Go to next message
jimit_shaili
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.

Regards

Jimit

Report message to a moderator

Re: text output from iSQL*PLUS [message #399499 is a reply to message #399392] Wed, 22 April 2009 08:54 Go to previous message
JRowbottom
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.

Report message to a moderator

Previous Topic: ORA-01460: unimplemented or unreasonable conversion requested
Next Topic: SQLPLUS: can substitution variable &1 have a default?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 16 16:09:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.