[#| 2010 - 10 -19T14: 33 : 51 . 432 + 0400 |SEVERE|glassfish3. 0 . 1 |javax.enterprise.system.std.com.sun.enterprise.v3.services.impl|_ThreadID= 35 ;_ThreadName=http-thread-pool- 8090 -( 1592 );|
***********ERROR***********
_init_: # headers= 46 
 declare nm  owa.vc_arr := ?;   
 	vl  owa.vc_arr := ?;   
 begin  
   owa.init_cgi_env( ?, nm, vl ); 
   htp.init;   htp.HTBUF_LEN :=  63 ;
    ? :=  sys_context('USERENV','SID');
 end;
SID: 30 
CALL:
begin 
 f(p=>?);
commit;
  end;
BINDS

p: 101 : 117 : 678819247236359 ::NO: 117 ::PAGE CALL:
declare 
   nlns        number :=  999999 ;
   l_clob      CLOB;
   lines       htp.htbuf_arr;
   l_buff      varchar2( 32767 );
   l_clob_init boolean:= false;
   l_file      varchar2( 5 );
 begin
    OWA.GET_PAGE(lines, nlns);
   if (nlns >  1 ) then
    for i in  1 ..nlns loop
       if ( length(lines(i)) >  0  ) then 
          if (  ( lengthb(l_buff) + lengthb(lines(i)))  >  32767 ) then 
   			if (NOT l_clob_init) then
  				dbms_lob.createtemporary(l_clob, TRUE); 
  				dbms_lob.open(l_clob, dbms_lob.lob_readwrite);
 			 	l_clob_init:=true;
 			 end if;
              dbms_lob.writeappend(l_clob,length(l_buff),l_buff);
               l_buff := lines(i);
          else
              l_buff := l_buff || lines(i);
          end if;
       end if; 
    end loop;
   end if;
   if (l_clob_init) then
      dbms_lob.writeappend(l_clob,length(l_buff),l_buff); 
      l_buff := ''; 
   end if; 
   ? := l_clob;
   ? := l_buff;
   if (wpg_docload.is_file_download) then l_file:='TRUE'; else l_file := 'FALSE'; end if;   ? := l_file;
 end;
 get_page FAILED:ORA- 06502 : PL/SQL: numeric or value error: character string buffer too small
ORA- 06512 : at line  32 

^^^^^^^^^^^^ERROR^^^^^^^^
|#]

[#| 2010 - 10 -19T14: 33 : 51 . 433 + 0400 |SEVERE|glassfish3. 0 . 1 |javax.enterprise.system.std.com.sun.enterprise.v3.services.impl|_ThreadID= 35 ;_ThreadName=http-thread-pool- 8090 -( 1592 );|ORA- 06502 : PL/SQL: numeric or value error: character string buffer too small
ORA- 06512 : at line  32 
|#]