-
truncated spooled text
Hi guys,
I spool a SELECT-statement into a ASCII-file.
The result, that is spooled, is a SELECT-statement. The spool file will be used as a script.
The problem is, that the lines get truncated after 100 caracters.
I tried to increase the linesize (SET LINESIZE 500), but that had no effect.
I tried to put many CHR(10) (linefeed) in the result statement, so the SELECT-statement is created over multiple rows, but now Oracle introduces extra linefeeds. The statements with extra linefeeds fail offcourse.
[edit]
The bottom line: I want to spool long select-statements without linefeeds.
[end edit]
Is there a setting for this?
Thanks in advance,
Erik
OS=MS Windows NT.
DB=Oracle 8.1.7.1.1
Last edited by efrijters; 09-04-2003 at 08:48 AM.
An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.
-
Is there any particular reason you are using ASCII format?
I use normal .txt or .lst with no problem.....or am I missing something.
What is the forcast lenght of your result script?
Able was I ere I saw Elba
-
With ASCII-file I just mean plain ASCII. Just a spooled file.
The length of the result is about 200 caracters.
I can solve the problem by manually correcting the result file, but that takes a lot of time.
Isn't there a function that can write to a text file? Maybe I can use that instead of the spooling mechanism.
An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|