Re: calling Oracle stored procedures from ASP/ADO

Not to all another reference point but if there is any place to use Oracle Objects For OLE (oo4o).
A good reference is http://groups.yahoo.com/group/oo4ole/ This group has sample code and answers to most of the common questions.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, November 27, 2002 4:44 PM

> I'm already in up to my neck supporting this developer.
>
> He knows next to nothing about Oracle, and it's been rather
> frustrating. Partly my own fault, I thought he did OK in the interview
> and would pick up the Oracle differences. Problem is, he doesn't
> seem to interested in doing so.
>
> sigh...
>
> I don't want to throw 'new' technology into the mix.
>
> Jared
>
>
>
>
>
>
> mantfield <mantfield_at_connexus.net.au>
> Sent by: root_at_fatcity.com
> 11/27/2002 12:16 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
> cc:
> Subject: RE: calling Oracle stored procedures from ASP/ADO
>
>
> Why are you / he / sh using ODBC ? OO4O is far superior and can make
> native
> DB calls using OCI, etc, at least that is what the VB guru contrator I
> have
> hired tells me, and I trust him. He says that ODBC compared to OO4O is a
> POS.
>
> The code he has written for me works like a charm, calls Oracle functions
> and SP with no problems, using in, out and in/out arguments
>
> Ferenc Mantfeld
>
> -----Original Message-----
> Sent: Thursday, November 28, 2002 6:15 AM
> To: Multiple recipients of list ORACLE-L
>
> Does anyone have a good example of this?
>
> We have a developer here that has been unable to
> figure out how to do this properly. Numerous examples
> from support.microsoft.com are apparently no help.
>
> A particular problem seems to be declaring the args
> properly, as he consistently gets and 'invalid type on parameter'
> error from ODBC.
>
> Thanks,
>
> Jared
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Jared.Still_at_radisys.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: mantfield
> INET: mantfield_at_connexus.net.au
>
> 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:
> INET: Jared.Still_at_radisys.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).