can't understand warnings in simple Pl/SQL function [message #512831] |
Wed, 22 June 2011 07:52 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/9b7e2c0ac90e50a012af74d7651cff53?s=64&d=mm&r=g) |
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 ?
|
|
|
|
|
|
|
|
|
|
|