dbms_output.get_lines problem

From: Martin Terpstra <terpstra_at_ats.nld.alcatel.nl>
Date: 1997/07/25
Message-ID: <33D8A8FD.15CC@ats.nld.alcatel.nl>#1/1

hello,

can anybody give me an working example how to use the get_lines() procedure of
the DBMS_OUTPUT package (or tell me what's wrong with the following example) ?

I am not able to compile a PL/SQL source using get_lines(). I always get the following error message:

PLS-00306: wrong number or types of arguments in call to 'GET_LINES'

---

Oracle7 Server Release 7.1.6.2.0 - Production Release With the parallel query option
PL/SQL Release 2.1.6.2.0 - Production

SQL>      DECLARE
  2          nummertje            INTEGER;
  3  
  3          TYPE CHARARRAY IS TABLE OF VARCHAR2(255)
  4          INDEX BY BINARY_INTEGER;
  5   
  5          ch_array         CHARARRAY;
  6  
  6          array_teller  binary_integer default 1;
  7  
  7        BEGIN
  8  
  8          dbms_output.enable(10000);
  9  
  9          dbms_output.put_line('Dit is een regel met tekst');
 10          dbms_output.put_line('Dit is regel twee met tekst');
 11          dbms_output.put_line('Dit is regel drie met tekst');
 12          dbms_output.put_line('Dit is regel vier met tekst');
 13          dbms_output.put_line('Dit is regel vijf met tekst');
 14  
 14          nummertje := 3;
 15  
 15          dbms_output.get_lines( ch_array, nummertje);
 16  
 16         END; 
 17  /
        dbms_output.get_lines( ch_array, nummertje);
        *

ERROR at line 15:

ORA-06550: line 15, column 9:
PLS-00306: wrong number or types of arguments in call to 'GET_LINES'
ORA-06550: line 15, column 9:

PL/SQL: Statement ignored

thanks,

-- 
Martin Terpstra                     Alcatel Telecom Nederland
Software Design Engineer            Engineering & Development
phone :  +31 (70) 3079-407          Burgemeester Elsenlaan 170
fax   :  +31 (70) 3079-191          2288 BH  RIJSWIJK
mailto:terpstra_at_ats.nld.alcatel.nl  NETHERLANDS

Received on Fri Jul 25 1997 - 00:00:00 CDT