PL/SQL Function Question

[EssJayKay]

Can a function take no input parameters as such:

function get_lo_post () return number
is
ret_value number;
begin
ret_value := 0;
select min(post) into ret_value from post_lookup;
return ret_value;
EXCEPTION
WHEN OTHERS THEN
return 0;
end;

I am getting an error on the declaration which is as follows:

function get_lo_post () return number;

 

[JediDan]

When a function or procedure takes no parameters, omit the ().

So your function signature would be:

function get_lo_post return number

Hope this helps.

 

[EssJayKay]

Thanks,

When calling the function should it be called with or without the parens?

 

[JediDan]

Either will work. I have a personal preference for always puting the parentheses in the code even if not needed, it improves readability (for me, at least).

Good luck.