RE: Re: passing an array variable from a .Net middle tier to a da

Nope. I'm not a fan of .not.

Some of the reasons are the lack of power and flexibility of the exception handling. The inconsistencey of calls, the fact that you need to do a round-trip from the page to the server to do most tasks (Jscript is available, but there is no integration with the code-behind. Some of that may have to do with the fact I'm using VB.NET instead of C# or J#.

It isn't very integrated with the database or the browser. A database NULL is not convertable to a integer. And in the HTML code its the string " ". In some cases you need to test for 3 values to test for "NULLness"

And most of all, other than early version of Forms 4.5, I've never had a tool loose so much of my code. If you aren't consistent in your use of the wizards and manual actions you run the risk of loosing your ASP code.

This may be windows specific, but within the last week I've found that the file locking is not reliable. That's right, I have simple code that shows that you can have 2 processes that can lock the same file at the same time! Email me offline and I'll send you the example. oracle-l_at_removethis.tuningoracle.com. Just remove the "removethis." from the address.

But, hey, it pays the bills.
Kevin

-----Original Message-----
Sent: Monday, November 10, 2003 2:20 PM
To: Multiple recipients of list ORACLE-L

sounds like your not a fan of .net, with the .not reference? why?
>
> From: Kevin Toepke <ktoepke_at_rlcarriers.com>
> Date: 2003/11/10 Mon PM 02:09:27 EST
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: RE: Re: passing an array variable from a .Net middle tier to a da
>
> Given that I've been developing in .NOT for the past 6 months, I figured
I'd
> chime in here....
>
> .NOT can call PL/SQL just fine. If you use Oracle's ODB.NET (that's Oracle
> Data Provider for .NET -- a free download from otn.oracle.com), you can
use
> bind an array to a PL/SQL call. In fact, if you look on OTN, you can find
an
> article titled.
> Bind an Array to an ODP.NET Database Command
>
> That said, I have never used the version provided by Micro$oft.
>
> Kevin
>
> -----Original Message-----
> Sent: Monday, November 10, 2003 1:59 PM
> To: Multiple recipients of list ORACLE-L
> databse
>
>
> hmm....
>
> earlier in the year i was on a project where I wrote alot of backend
PL/SQL
> that was called through the middle tier. I have no idea how this works. I
> just assumed it came straight through .NET.
>
> any idea how they might have done that? The front end was a .NET
> architecture. Sorry for being vague, my extent of knowledge on .NET ends
> with how to spell it.
>
> If you cant call PL/SQL from .NET than that is a huge weakness in
> comparisons to java. Will microsoft add featurse to all this? I would
think
> they might not because they want people using SQL Server.
>
> Our .NET architect swears by it and claims .NET has alot of advantages
over
> java.
> >
> > From: David Hau <davehau123_at_netscape.net>
> > Date: 2003/11/10 Mon PM 01:44:27 EST
> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > Subject: Re: passing an array variable from a .Net middle tier to a
> databse
> >
> > You can't use a PL/SQL table in ODP.NET. ODP.NET currently does not
> > support object type or collection type:
> >
> >

>
http://forums.oracle.com/forums/thread.jsp?forum=146&thread=211399&tstart=0&
> trange=15
> >
> > Your best bet would be to use array binding i.e. bind an array to the
> > OracleParameter object and set the ArrayBindCount in the OracleCommand
> > object:
> >
> > http://download-west.oracle.com/docs/html/A96160_01/features.htm#1049674
> >
> > HTH,
> > Dave
> >
> >
> >
> >
> > ryan_oracle_at_cox.net wrote:
> > > Im sure on the DB side this is the same for Java and C/C++ also.
> > >
> > > The OO guys pass us an array. When I write my code, I need to define a
> PL/SQL table that maps exactly to the array correct?
> > >
> > > Our middle tier is having problem doing bulk inserts since its doing
one
> at a time and I believe it closes the session each time. I also think
there
> is an auto-commit on.
> > >
> > > I cant help with that... However, I want to pass it to a pl/sql table
> with some other variables then dynamically insert it into the database
from
> package. This should clear up the bottleneck.
> > >
> > > is this doable? I cannot touch the middle tier or OO stuff. Strictly
the
> database.
> > >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: David Hau
> > INET: davehau123_at_netscape.net
> >
> > 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.net
> --
> Author: <ryan_oracle_at_cox.net
> INET: ryan_oracle_at_cox.net
>
> 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.net
> --
> Author: Kevin Toepke
> INET: ktoepke_at_rlcarriers.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.net
-- 
Author: <ryan_oracle_at_cox.net
  INET: ryan_oracle_at_cox.net

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.net
-- 
Author: Kevin Toepke
  INET: ktoepke_at_rlcarriers.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).