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

Home -> Community -> Usenet -> c.d.o.misc -> Re: ASP and Oracle

Re: ASP and Oracle

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Wed, 16 Jul 2003 19:14:48 -0700
Message-ID: <3F160698.D77083C7@exxesolutions.com>


Michael Rothwell wrote:

> I have been asked to look into porting an ASP system to an Oracle DB.
> Currently, they are using SQL Server and retrieving data via stored procs. I
> know how to migrate the DB, but what work will have to be done to the ASP code
> to be able to access the Oracle DB as well as the SQL Server DB?
> --
> Michael Rothwell

You do understand you will need to rewrite every proc to have a REF CURSOR as an OUT parameter?

If connecting via ODBC and all SQL is in the procs ... essentially nothing need be changed. If the SQL is being
passed through ... everything needs to be rewritten.

And if you don't take multi-versioning and the Oracle transaction model into account you will just make a huge,
unscalable poorly performing mess.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Wed Jul 16 2003 - 21:14:48 CDT

Original text of this message

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