[lynxee]

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

[anacedent]

set arraysize 1

[lynxee]

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