Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: What is the difference between procedure and function?

Re: What is the difference between procedure and function?

From: Devinder Pal Singh <Devinder_Pal.Singh_at_pharma.novartis.com>
Date: Mon, 21 Sep 1998 14:39:16 -0400
Message-ID: <36069D54.2D12@pharma.novartis.com>


> >> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US