As I correct the error? -ORA-06550 -PLS-00357
685925Mar 15 2009 — edited Mar 15 2009*{color:#0000ff}Good morning*
* I am trying to generate a file extension. txt,
extracting information from a table called test, and I generated the
following error ORA-06550: - and - PLS-00357:{color}*
CREATE TABLE ENSAYO
(
CODIGO NUMBER,
FECHA DATE DEFAULT sysdate,
NOMBRE VARCHAR2(40)
)
;
insert into ensayo values(1,'12-12-2009','rey');
insert into ensayo values(2,'10-02-2009','luna');
insert into ensayo values(3,'16-03-2009','paola');
insert into ensayo values(4,'16-03-2009','Natalia');
set serverout on;
DECLARE
v1 utl_file.file_type;
v2 varchar2 (100);
begin
v1:= utl_file.fopen('PUBLIC_ACCESS','prueb'||to_char(sysdate,'yyyymmdd')||'.txt','w');
loop
utl_file.put_line(v1,ensayo.codigo);
end loop;
utl_file.fclose(v1);
exception
when others then
dbms_output.put_line(sqlerrm);
end;
/
*{color:#ff0000}*
utl_file.put_line(v1,ensayo.codigo);
***
*{color}{color:#ff0000}ERROR en lÝnea 7:*
ORA-06550: lÝnea 7, columna 32:*
PLS-00357: La referencia a la tabla, vista o secuencia 'ENSAYO.CODIGO' no estß*
permitida en este contexto
ORA-06550: lÝnea 7, columna 4:
*PL/SQL: Statement ignored{color}*
*{color:#0000ff}As I correct the error?*
* Thank you very much for your cooperation ...*
* good day ...*
*{color}*
*{color:#0000ff}*
*{color}*
*{color:#0000ff} Reynel Martinez Salazar.{color}*