Re: DB connectivity

On Sat, 07 May 2005 02:43:36 -0700, madunix interested us by writing:

> I am in the procees to implement private area to our main webstite on
> the internet.
> The private zone will allow authorized individual person inside and
> outside the country to view his/her own data and transaction
> For membership sign in, if they have paid. Payment would be made either
> by coming in person to Main Office or electronically by e-pay
> Our Backend Database Server running Oracle 9i web application on
> PowerPC pSeries UNIX AIX 5L
>
> I am looking for a solution to pull up live data between form Backend
> Database Server to the web server.
>
> Would it be better to retrieve Data from DB oracle through PHP ASP
> ...etc. or through oracle portal solution?

As you research this, remember to look at the Oracle Supplied [PL/SQL | Java) manuals to learn some of the functionality that is included.

I have found that often people have duplicated Oracle built-in functionality (at a cost, including lengthening project delivery) which requires maintenance (also at a cost)

On the flip side, there is a cost to learning these features and possibly the language.

Oracle's DB docco includes several very important manuals - assuming you are comfortable with Oracle Concepts (not just generic DB concepts) I encourage you to look at the 'Application Developer' set of manuals.

ALso note that anything built into, or runnning in, the database that specifically impacts the data will often have better performance characteristics than implementing the same functionality remotely.

/Hans

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***