Tags: 10g, additional, command, database, mysql, oracle, release, serveroutput, size, sql, steps, unlimited, working
set serveroutput on size UNLIMITED
Set serveroutput on size Unlimited is not working on 10g release 2.
Is there any additional steps to be taken to make the above command work ?
Leave a comment...
- 3 Comments
- < Is there any additional steps to be taken to make the above command work ?
Not that I'm aware of. What makes you think its not working? What syntax are you using?#1; Sun, 24 Feb 2008 00:50:00 GMT
- well, I still get
ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes.
after using the syntax SET SERVEROUTPUT ON SIZE UNLIMITED.#2; Sun, 24 Feb 2008 00:51:00 GMT
- Are you sure that you've got a 10.2 version of SQL*Plus as well as a 10.2 version of the database? Or are you using an older version of SQL*Plus to connect to a 10.2 database (or vice versa)?
Justin#3; Sun, 24 Feb 2008 00:52:00 GMT