ORU-10027 Buffer overflow
When running a SQL script, I got error ORU-10027 Buffer overflow,limit of 2000 byte. How to set a biger buffer, I tried
set buffer ??? , but did not work.
Another question is , how to use spool command to let the SQL output
going to a file.
I would suggest RTM first especially this one - Oracle Concepts
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Do u want to spool the data from table.
Just try the following steps.
1. select * from table name;
2. Go to File
3. Select Spool
4. Give a Spool file name
5. Just enter the /
6. GO to file
7. Select Spool
8. Select Spool off
9. It will save as LST file
10.Open the LST file in XL or Word.
Click Here to Expand Forum to Full Width