Home » SQL & PL/SQL » SQL & PL/SQL » Re: To PL/SQL Experts: ORU-10028: line length overflow, limit of 255 bytes per line.
Re: To PL/SQL Experts: ORU-10028: line length overflow, limit of 255 bytes per line. [message #20850] Tue, 25 June 2002 12:12
andrew again
Messages: 2577
Registered: March 2000
Senior Member
dbms_output.put_line(v_long_text, 1, 200);
dbms_output.put_line(v_long_text, 201, 400);

create or replace procedure p( p_string in varchar2 )
   is
      l_string long default p_string;
   begin
      loop
        exit when l_string is null;
        dbms_output.put_line( substr( l_string, 1, 250 ) );
        l_string := substr( l_string, 251 );
      end loop;
   end;
/

begin
 p(lpad('>', 1000, 'x'));
end;
/

Previous Topic: Re: ORU-10028: line length overflow, limit of 255 bytes per line
Next Topic: From Records to Ref Cursor
Goto Forum:
  


Current Time: Fri Jul 19 23:21:55 CDT 2019