How can I deal with this exception"buffer flow" when I use cursor. [message #306793] |
Sun, 16 March 2008 20:46  |
crazyzhou
Messages: 38 Registered: March 2008 Location: china
|
Member |
|
|
Does somebody can help me?
the following is the codes:
DECLARE
CURSOR tabs_cur(b_owner VARCHAR2) IS
SELECT table_name FROM all_tables@rcdc WHERE owner = b_owner;
BEGIN
FOR cursor_rec IN tabs_cur('CDC') LOOP
dbms_output.put_line(cursor_rec.table_name);
END LOOP;
END;
ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
ORA-06512: 在"SYS.DBMS_OUTPUT", line 35
ORA-06512: 在"SYS.DBMS_OUTPUT", line 198
ORA-06512: 在"SYS.DBMS_OUTPUT", line 139
ORA-06512: 在line 6
SQL> select count(*) from all_tables@rcdc where owner = 'CDC';
COUNT(*)
----------
2124
thanks.
|
|
|
|
|
|