Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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}*

This post has been answered by Solomon Yakobson on Mar 15 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 12 2009
Added on Mar 15 2009
2 comments
597 views