A problem with a function [message #600894] |
Wed, 13 November 2013 11:49 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/9996a32bf69a26d576c355127fae6a6d?s=64&d=mm&r=g) |
amjad_alahdal
Messages: 102 Registered: October 2013 Location: Saudi Arabia
|
Senior Member |
|
|
hello every one
I created a function that gives me a full name from a table named oracle_waqf but it gives me errors when I try to compile it,
this is the function
FUNCTION get_name(benef_id number) RETURN VARCHAR2 IS
re_val varchar2(250) ;
BEGIN
SELECT FULL_NAME
INTO re_val
FROM ORACLE_WAQF where BENEFICIARY_NUMBER=benef_id ;
return re_val ;
END;
the problem , identifier oracle_waqf must be declared
|
|
|
|