Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Can't code for s.... peanuts
to execure procedures:
execute proc_name(parms);
for functions.
select function_name(parms) from dual;
you can't execute a function just like it says.
joe
>>> oqij4ngfcrweuh001_at_sneakemail.com 07/23/01 02:27PM
>>>
Hi again everybody,
I'll try to be as descriptive as possible, sorry if
I leave anything important out.
I have the following function which I'm compiling
using PL/SQL Developer (tnx Djordje).
CREATE OR REPLACE FUNCTION check_for_name
(p_name_to_check VARCHAR)RETURN BOOLEAN
ISCURSOR c_namestbl ISSELECT
lnameFROM namesWHERE lname =
p_name_to_check;v_return_value
BOOLEAN;BEGINOPEN c_namestbl;IF
c_namestbl%NOTFOUND THENv_return_value :=
FALSE;ELSIF C_namestbl%FOUND
THENv_return_value := TRUE; END
IF;RETURN v_return_value;CLOSE
c_namestbl;END check_for_name;
It compiles without errors (now).
The table 'names' is built like this :
SVRMGR> DESCRIBE names;Column
Name Null? Type------------------------------ -------- ----FNAME VARCHAR2(20)LNAMEVARCHAR2(20)SVRMGR>
LNAME-------------------- --------------------Bruce WillisSalma HayekTom CruiseElle