Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Accessing one varray element within SQL query

Re: Accessing one varray element within SQL query

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Mon, 12 Jan 2004 18:29:14 -0800
Message-ID: <1073960877.964288@yasure>


Rene Nyffenegger wrote:

>>Even if it does ... the OP should not be connecting directly to a table.

>
>
> Why's that?
>
> Rene

There are security and data type issues between large blocks of Microsoft's code and Oracle. All of these are easily resolved by creating your own APIs ... using procdures ... and just passing parameters. It also makes the client thinner which means faster loading and better performance and scalability.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Mon Jan 12 2004 - 20:29:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US