DBMS_OUTPUT [message #316300] |
Thu, 24 April 2008 09:39 |
xyzt
Messages: 27 Registered: April 2008
|
Junior Member |
|
|
hello,
i try to run a simple script but i get error:
declare
cursor my_cur is
select * from THUF;
rec my_cur%ROWTYPE;
begin
open my_cur;
loop
fetch my_cur into rec;
exit when my_cur%NOTFOUND;
exec dbms_output.put_line(rec.FL);
end loop;
close my_cur;
end;
when i run
exec dbms_output.put_line('test');
it outputs but the above script gives error:
ORA-06550: line 10, column 7:
PLS-00103: Encountered the symbol "DBMS_OUTPUT" when expecting one of the following:
:= . ( @ % ;
The symbol ":=" was substituted for "DBMS_OUTPUT" to continue.
as you see, i'm a newnewnewbie...may someone show me my fault please?
thanks in advance...
|
|
|
|