Go to the FreeLists Home Page Home Signup Help Login
 



[oracle-l] || [Date Prev] [05-2004 Date Index] [Date Next] || [Thread Prev] [05-2004 Thread Index] [Thread Next]

Re: Re: Wrapping all tables with packages and scalability

  • From: <ryan.gaffuri@xxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx, <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 3 May 2004 8:41:48 -0400
don't quite follow one point in your post. What do you mean, I nee dto use 
object types for each row in a table? I thought the norm was to use a REF 
Cursor? 


> give your procedures the same number of parameters as there are columns
> in the table, then you're hardly gaining anything. You MUST use object types
> as the procedure interface parameters, where each object type is a row of
> the
> table (or a part thereof).
> 
> Cheers
> Nuno Souto
> in sunny Sydney, Australia
> dbvision@xxxxxxxxxxxxxxx
> 


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------




[ Home | Signup | Help | Login | Archives | Lists ]

All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
Everything else ©2007 Avenir Technologies, LLC.