DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: truncated spooled text

  1. #1
    Join Date
    Oct 2002
    Location
    Breda, The Netherlands
    Posts
    317

    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.

  2. #2
    Join Date
    May 2003
    Location
    Pretoria, Rep of South Africa
    Posts
    191
    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

  3. #3
    Join Date
    Oct 2002
    Location
    Breda, The Netherlands
    Posts
    317
    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
  •  


Click Here to Expand Forum to Full Width