HELP : PL/SQL SPEED Functions
From: Joao Ricardo B Oliveira <jricardo_at_ipb.pt>
Date: Mon, 23 Aug 1999 14:52:42 +0100
Message-ID: <7prj17$s8g$1_at_pan.ipb.pt>
Hi there:
return('Not Found');
end func_get_description;
Date: Mon, 23 Aug 1999 14:52:42 +0100
Message-ID: <7prj17$s8g$1_at_pan.ipb.pt>
Hi there:
[Quoted] I've created a function to get the description of a product, by entering the ID...
this function is used several times by al the application...
I've speed problems, when in my application (FORMS 4.5) invoke the function for example :
:order.description:=func_get_description(:order.ID)
If i write the function code in the POST_CHANGE trigger is MUCH FASTER than invoking the function.
Shouldnt be the opposite ?
the function have the follow code:
function func_get_description(xid number) return char
desc varchar2(80)
begin
select description into desc
from prod
where id=xid;
exception
when no_data_found then
return('Not Found');
end func_get_description;
- mail me please...
- Joao Ricardo B Oliveira jricardo_at_ipb.pt
-
- Oracle DBA http://www.ipb.pt/~jricardo
- Joao Ricardo B Oliveira jricardo_at_ipb.pt