Home » Developer & Programmer » Application Express & MOD_PLSQL » A problem with a function
A problem with a function [message #600894] Wed, 13 November 2013 11:49 Go to next message
amjad_alahdal
Messages: 39
Registered: October 2013
Location: Saudi Arabia
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

Re: A problem with a function [message #600896 is a reply to message #600894] Wed, 13 November 2013 11:53 Go to previous message
amjad_alahdal
Messages: 39
Registered: October 2013
Location: Saudi Arabia
Member
I am so sorry, I found out that I was not connected to Oracle Server,,,,
can anyone delete the topic .....
Previous Topic: Changing the default date to DD-MM-YYYY
Next Topic: Apex: Changing page submit Waiting/Loading Image
Goto Forum:
  


Current Time: Fri Oct 31 20:10:45 CDT 2014

Total time taken to generate the page: 0.08827 seconds