Re: Accessing An ORACLE Database In A WebSphere Environment

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Tue, 11 Feb 2003 00:24:14 -0800
Message-ID: <3E48B32E.E141A189@exesolutions.com>

"news.vianet.net.au" wrote:

> Hi Oracle Users
>
> At the risk of alienating myself really early in the mail, I am an IIS / ASP
> / Microsoft user. Forgive me - I'm not worthy.
>
> I need to access an ORACLE database in an IBM WebSphere web environment.
>
> My preferred method, due to my previous experience, is to write some
> back-end ASP or javascript pages to accept some HTTP POST parameters and
> then use these params to fashion some SQL to access the ORACLE data, then
> generate some RESPONSE.WRITEs to prove that I actually read it!
>
> Does anyone have any sample script that does something similar to what I'm
> asking and works under WebSphere (or at least should!).
>
> Thanks a million
>
> PeteB

Can't help you with the script but my advice would be to put the SQL into packages in the database and pass parameters in and receive REF CURSORS back out.

Doing so will improve performance, scalability, and stability.

Daniel Morgan Received on Tue Feb 11 2003 - 02:24:14 CST