Function Create but Statement is Ignored

Question

enter image description here

Hello everyone, please help me again!

I could create the function but when I execute it, I always get the following error. Line 1, column 7 (I guess it's datatype of parameter) and statement ignored! :(

Reading error messages for fun and profit... `'FCT1' is not a procedure or is undefined` — Jeffrey Kemp, Mar 10 '14 at 03:58

score 2 · Accepted Answer · edited Mar 03 '14 at 11:57

2

What you are using is to execute a function. Either assign the result to a variable or run sql query using dual

 declare
    x varachar2(100);
 begin
    x := fct1('dd');
 end;

Alternatively you can also use

select fct1('dd') from dual;

edited Mar 03 '14 at 11:57

Nick Krasnov

26,886
6
61
78

answered Mar 03 '14 at 11:35

simplify_life

405
4
18

Function Create but Statement is Ignored

1 Answers1