Home » SQL & PL/SQL » SQL & PL/SQL » DBMS_OUTPUT
DBMS_OUTPUT [message #316300] Thu, 24 April 2008 09:39 Go to next message
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...
Re: DBMS_OUTPUT [message #316301 is a reply to message #316300] Thu, 24 April 2008 09:42 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Don't use EXEC. It's not a SQL command, not pl/sql.
Previous Topic: PLS-00103: error
Next Topic: budgetdata
Goto Forum:
  


Current Time: Fri Dec 13 00:29:40 CST 2024