From: Joao Ricardo B Oliveira <>
Date: Mon, 23 Aug 1999 14:52:42 +0100
Message-ID: <7prj17$s8g$>

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 :


    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)

        select description into desc
        from prod
        where id=xid;
        when no_data_found then

    return('Not Found');
    end func_get_description; Received on Mon Aug 23 1999 - 15:52:42 CEST

Original text of this message