can't understand warnings in simple Pl/SQL function [message #512831] |
Wed, 22 June 2011 07:52 |
|
daudiam
Messages: 51 Registered: June 2011
|
Member |
|
|
I am using Oracle 10g with SqlDeveloper. When I execute the following code, it says
"FUNCTION wafadar compiled Warning: execution completed with warning"
create or replace function wafadar
return varchar2(10)
is
cursor c1 is
SELECT employee_id,first_name FROM employees where department_id=50 ;
begin
for i in c1
loop
dbms_output.put_line(i.first_name);
end loop;
return 'hello';
end;
SHOW ERRORS at the end is also not showing the warnings. Why are the warnings there ?
|
|
|
|
|
|
|
|
|
|
|