Re: ASP and Oracle

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)