| A problem with a function [message #600894] |
Wed, 13 November 2013 11:49  |
 |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
