| dbms_output.put_line [message #376149] |
Tue, 16 December 2008 05:29  |
bhangale.parag
Messages: 11
Registered: December 2008
Location: culcutta
|
Junior Member |
|
|
hi all,
dbms_output.put_line having max limit is 1000000 but my clob result is near about 500 MB so how can i manage it can you please give me any idea???????????????
|
|
|
|
| Re: dbms_output.put_line [message #376158 is a reply to message #376149] |
Tue, 16 December 2008 05:46  |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Why would you ever want to use DBMS_OUTPUT to display that much data?
DBMS_OUTPUT is intended as a lightweight text output device, useful for debugging, and sometimes for output from utility programs like UT-Pl/SQL.
For any other purpose, there are better things to use.
I'd use either UTL_FILE if I wanted to write it to a file on disc, or a front end like Forms that could handle large text fields if I wanted to display it.
If you tell us what you're trying to do, then we may be able to proovide more detailed help.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: dbms_output.put_line [message #376211 is a reply to message #376149] |
Tue, 16 December 2008 08:38 |
trivendra
Messages: 211
Registered: October 2007
Location: Phoenix
|
Senior Member |
|
|
Hi,
As mentioned above UTL_FILE package has restriction.
I used some simple example of spooling the file on local machine.
This work fine for both the OS : UNIX and Windows Family.
a) Create a folder On you machine on some Location, for my machine it is
C:\TEMP\Trivendra\Example
b) Create a file with the some, like execute.sql
Copy and paste the following script in this file.
set echo off
set linesize 1000
set verify off
set feedback off
set heading off
set head off
set trim on
set trimspool on
set sqlprompt ''
spool C:\TEMP\Trivendra\Example\result.txt
select level from dual connect by level <=10;
spool off;
Here you can put your query which has CLOB column.
b) Create a batch file with some name, like run.bat
copy and paste this code in run.bat batch file.
sqlplus scott@skype @C:\TEMP\Trivendra\Example\execute.sql
c) Just Run the batch file, you will find your data in you spool location, and here it is Result.txt.
Thanks
Trivendra
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
