Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    2

    Red face Unanswered: Error buffer overflow when select the source from the database.

    currently I am using the SQLPLUS:

    Here i follow some of the archive article from this dbforums.

    to see the source code directly from the database, type
    SQL> SELECT * FROM USER_SOURCE WHERE OBJECT_NAME = 'PART_INSERTING870_PR';

    then i encounter this error message;
    ERROR at line 1:
    ORA-00904: invalid column name

    Then i describe the user_source;
    SQL> desc USER_SOURCE;
    Name Null? Type
    ------------------------------- -------- ----
    NAME NOT NULL VARCHAR2(30)
    TYPE NOT NULL VARCHAR2(12)
    LINE NOT NULL NUMBER
    TEXT VARCHAR2(4000)

    After that i reselect again the source code:
    SQL> SELECT * FROM USER_SOURCE WHERE NAME = 'PART_INSERTING870_PR';

    then it prompt me this message;
    buffer overflow. Use SET command to reduce ARRAYSIZE or increase MAXDATA.

    I try set arraysize 100, but still got the same error message buffer overflow.

    What should i do next in order for me to see this source code? Anyone can help me here.

    Regards
    Last edited by lynxee; 09-18-03 at 21:33.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    set arraysize 1

  3. #3
    Join Date
    Sep 2003
    Posts
    2

    Cool

    i've done the arraysize 1 but still the same.

    Nevermind i got the answer already after i try the command below:
    set line 200
    set pagesize 1000
    set arraysize 1

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •