Which technology to use?

Hi all.

If I wanted to develop a web interface with Oracle backend in Unix, what technologies should I consider? We have both Unix and NT/IIS web servers.

Java is a good option.
Also consider oracle application server.

Use PSP(PL/SQL Server Pages). This is Oracle native version and it is almost similiar to JSP. All pages are stored in the database as stored procedures.

i have used it and it is very useful.

any other queries, please revert back.

Tks

Das

I agree with Partha PSP's offer a simple way of producing web content directly from the database without additional investment (if you already have PL/SQL developers).

Regards

Hi.

I've used JSP, Servlets, ASP, ASP.NET, PHP, Oracle Web Toolkit, PSP etc and they are all pretty much the same. You can do PSP, Web Toolkit and JSP straight from the database as you have Apache running their anyway.

In the long term most enterprise solutions will probably stick with ASP.NET and JSP, but this doesn't mean the others aren't valid. The whole of the asktom.oracle.com site is done using PL/SQL stright from the database. Have a play around with them all and see what suits you best. Here's some starting points:

http://www.oracle-base.com/Articles/...bToolkit9i.asp
http://www.oracle-base.com/Articles/...verPages9i.asp
http://www.oracle-base.com/Articles/...verPages9i.asp

Cheers

Tim...

Thanks everyone. Tim, you mentioned ASP.NET being a popular enterprise choice; that's good to hear, as I was looking at using it, but I'm not sure how well it works with Oracle?

If you mean connectivity:

You can use the odbc.net , with mdac to connect to oracle.
More or less like using a vb app front ending oracle...