Re: Stored Procedure Question

Of course it is, but only if it is standalone procedure/package. But the performance of calling subprogram is VERY bad. So, if the output from select has ..hmmm... 2.000 touples .......

I had the same problem :-)
I wrote function IsRowAvailable(user_id,row_id) in my own package Security (the same princip - to tell if the row is avaliable to user). But I moved very quickly to EXISTS operator. :-) (Oracle 8.1.7)

Jan Pruner

On Monday 05 August 2002 14:08, you wrote:
> 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

-------------------------------------------------------

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