Re: Stored Procedure Question

correct me if I am wrong but isn't calling a stored procedure better fro performance ?

Gavin

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, August 05, 2002 4:38 PM

The statement WITHOUT calling function/procedure has better performance.

JP

On Monday 05 August 2002 12:23, you wrote:
> Hi All,
> Suppose I have a SQL statement like
>
> select c.contentid,content_pkg.getlicences(c.contentid) from content
>
> which calls a package.
> If I replace it with
>
> select c.contentid,(select licences from licences where contentid
> =c.contentid) from content
>
> would there be any difference in performance ?
>
> I know this is trivial but in my quest for solving an open_cursor problem
> in Oracle8i I have noticed that unnamed cursors do not get closed. The
> first statement calls a package which calls an unnamed cursor, increases
> the number of open cursors by 1.
> The second statement does not increase the number of open cursors. Is
> it feasible to replace the first statement by the second ?
>
> I would appreciate any help,
>
> Thank You,
>
> Gavin

--
         Pruner Jan
       jan_at_pruner.cz
     http://jan.pruner.cz/
-----------------------------
Only Robinson Crusoe had all his work done by Friday
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jan Pruner
  INET: jan_at_pruner.cz

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gavin D'Mello
  INET: gavin_d_at_tis.co.in

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).