Home » SQL & PL/SQL » SQL & PL/SQL » File on Client Machine
File on Client Machine [message #376352] Wed, 17 December 2008 01:43 Go to next message
bhangale.parag
Messages: 11
Registered: December 2008
Location: culcutta
Junior Member
hi all,
I am back again,
I have one question can i create a file on oracle client machine without using spool???

please reply.........
Thanks in advance

Thanks
Parag

[Updated on: Wed, 17 December 2008 01:49]

Report message to a moderator

Re: File on Client Machine [message #376353 is a reply to message #376352] Wed, 17 December 2008 01:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.
Creating a file on client is a matter of client program not Oracle rdbms.

Regards
Michel
Re: File on Client Machine [message #376355 is a reply to message #376352] Wed, 17 December 2008 01:49 Go to previous messageGo to next message
trivendra
Messages: 208
Registered: October 2007
Location: Noida, India
Senior Member
Just copy and paste the ouput of your sqlplus result in your local machine.
Re: File on Client Machine [message #376358 is a reply to message #376353] Wed, 17 December 2008 01:54 Go to previous messageGo to next message
bhangale.parag
Messages: 11
Registered: December 2008
Location: culcutta
Junior Member
thanks for replying
my problem is like this...........
I want to create my database XML export but my query is getting too long it gives me "String literal too long" so i have created one stored procedure for it which returns me a clob so i have write that clob into file on client machine so i can do it??

and also my clob size is too long...........

[Updated on: Wed, 17 December 2008 01:58]

Report message to a moderator

Re: File on Client Machine [message #376362 is a reply to message #376358] Wed, 17 December 2008 02:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read the topic: http://www.orafaq.com/forum/t/137505/102589/

Why don't you want to use spool?

Regards
Michel
Re: File on Client Machine [message #376377 is a reply to message #376358] Wed, 17 December 2008 03:13 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You're just going to have to bite the bullet and talk to your DBA about getting a directory set up for UTL_FILE.
That's the best tool for writing out from the database.
Re: File on Client Machine [message #376596 is a reply to message #376352] Thu, 18 December 2008 00:07 Go to previous messageGo to next message
idris.ali
Messages: 34
Registered: June 2008
Location: Hyderabad
Member
If your clob data can fit into varchar2

you may use something like
select dbms_lob.SubStr(clob_data) from clob_table;

and spool the output to a file.
Re: File on Client Machine [message #376607 is a reply to message #376596] Thu, 18 December 2008 00:33 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
and spool the output to a file.

And OP said:
Quote:
without using spool

So great answer!

Regards
Michel
Previous Topic: simple join query
Next Topic: select query
Goto Forum:
  


Current Time: Sat Dec 10 16:34:26 CST 2016

Total time taken to generate the page: 0.06357 seconds