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@pan.ipb.pt>

Hi there:

    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

    ---

Received on Mon Aug 23 1999 - 08:52:42 CDT