DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2001
    I am trying to dump the content of a view into a text file. I am following the steps below

    1. select the colmn to cursor
    2. Fetch cursors into variables
    3. concatinate all variables into a single string
    4. Write to string using UTL_FILE package.

    I have the problem in step 3, where I am trying to concatinate all the cursor values to a single varchar variable.
    I get the following error
    ERROR at line 1:
    ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
    ORA-06512: at "SYS.DBMS_OUTPUT", line 106
    ORA-06512: at "SYS.DBMS_OUTPUT", line 65
    ORA-06512: at "MNDB.RESPONSE_FILE", line 310
    ORA-06512: at line 1

    Lenght of all the columns in the view will not exceed 1200 characters
    Please help me;

  2. #2
    Join Date
    Nov 2000
    THis question is answered in [url]http://www.dbasupport.com/forums/showthread.php?threadid=6330[/url]
    Jeff Hunter
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.