Home » Developer & Programmer » Application Express, ORDS & 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: 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

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: 102
Registered: October 2013
Location: Saudi Arabia
Senior 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 Mar 29 09:50:22 CDT 2024