| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> Re: What is the difference between procedure and function?
> >> Can anyone tell me what it means?
> >>
> >> --
> >> Best regards,
> >>
> >
> >-----== Posted via Deja News, The Leader in Internet Discussion ==-----
> >http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
You can run like
select function_name(para) from dual;
Oracle checks the purity of functions if you have used dbms_output
package you cannot execute it like this, because oracle doesnot consider
dbms_output package as pure.Donot ask me what this purity is.
the other rhing that you can do is
declare
out_par number;
begin
out_par := your_function(your_para);
dbms_output.put_line(out_par);
end;
/
Received on Mon Sep 21 1998 - 13:39:16 CDT
![]() |
![]() |