Re: .NET and Oracle

Microsoft has a .Net provider as well as Oracle ODP (OTN under Windows).

In my experience if you want to use the following data types use Oracles, if not use Microsofts.

1) CLOB
2) BLOB
3) BFILE
4) XML Data type

The Oracle ODP does not allow you to build the Procedures or Functions Parameters so you must Prepare each in.ou/in out parameter. Microsoft allows you to build the parameter collection, similar to the COM (regular ADO Providers).

If you need some examples let me know.

Regards,
Jay

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, November 15, 2002 6:13 PM

> Harvinder - My experience is that Microsoft will try to imply that, just
> like an Oracle sales rep will try to imply that Oracle works better with
> Oracle9i AS. But the fact is that if Microsoft enforced that rule, it
would
> be excluded from a lot of big accounts that have a lot more committed to
> Oracle than they do to .NET. However, my experience is that the Microsoft
> data interfaces like ADO frequently have poor performance. Since Microsoft
> and Oracle aren't real chummy, there are few documents to help you out.
>
>
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com <mailto:dwilliams_at_lifetouch.com>
>
> -----Original Message-----
> Sent: Friday, November 15, 2002 3:59 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi,
>
> I read somewhere that .NET application will only be supported with SQL
> Server.
> Is this true or it can be run with any other database like Oracle?
>
> Thanks
> --Harvinder
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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: Jay
  INET: fish_dba_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).