Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

This is probably a silly question, but I'm not an oracle admin so I'm not sure. Our client currently runs a website written in PL/SQL and HTML on a Oracle 10G system. As everything is moving in the direction of 11G the question has come up, will our current PL/SQL system keep working.

I guess the real question here is where does PL/SQL code execute? I know the 11G database supports PL/SQL. I'm just unsure about how Oracle is integrating what used to be Application Server into WebLogic Application Server.

share|improve this question

1 Answer 1

The PL/SQL runs in the database, and so any changes on the application server won't affect the actual execution of PL/SQL code. However, it may still impact on the final result, eg. how the application presents itself to the user, depending on how the application is built.

As for PL/SQL compatibility between Oracle Datababase 11G and 10G you will likely have to do minor modifications in the code. I believe Oracle is claiming backwards compatibility, but in my experience with previous releases there are always a few things that needs tweaking.

share|improve this answer
    
We're aware of the little issues that can come up from migrating the database so that shouldn't be a major problem. As long as the new Weblogic app server will serve up our PL/SQL pages, we can make whatever other changes need be made. –  Saabster Oct 8 '09 at 14:34
    
Also, thanks for the reply –  Saabster Oct 8 '09 at 14:38

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.