PL/SQL (MOSC)

MOSC Banner

Getting the below error

edited Apr 21, 2013 11:55PM in PL/SQL (MOSC) 3 commentsAnswered ✓
 Hi,I am facing the below error can any body please suggest how can i fix this

Error starting at line 1 in command:
declare
l_locator_id number;
l_locator_name varchar2(100);
l_err_code number;
l_err_msg varchar2(100);
begin
pr_get_next_cc_location_t(121,56024,1,1,l_locator_id,l_locator_name,l_err_code,l_err_msg);
dbms_output.put_line(l_locator_id||'                    '||l_locator_name);
dbms_output.put_line(l_err_code||'            '||l_err_msg);
end;
Error report:
ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes
ORA-06512: at "SYS.DBMS_OUTPUT", line 32
ORA-06512: at "SYS.DBMS_OUTPUT", line 97

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center