Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » impact on app code due to migration from 8i to 9i
impact on app code due to migration from 8i to 9i [message #77189] Wed, 03 November 2004 02:10 Go to next message
arun
Messages: 67
Registered: January 2000
Member
hi,

I am migrating my application from oracle 8i to oracle 9i.the middle tier is VB and front end is ASP.

I need to know the impact on the VB code due to migration from 8i to 9i.

There are thousands of queries and stored procedures which will be migrated to 9i. What are the potential bottlenecks to watch out for

This is mainly from code porting point of view.

thanks

arun.
Re: impact on app code due to migration from 8i to 9i [message #77190 is a reply to message #77189] Wed, 03 November 2004 06:27 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
All of the existing SQL run the same, but the 9i PL/SQL compiler is stricter than in 8i. A common error encountered is when the parameter defaults in package Specs and Bodies don't match exactly. Try to compile the 8i code in 9i and then just fix the Spec or Body. It't quick to fix and doesn't require much skill once you've decided if the Spec or Body is right...
Previous Topic: oracle and XML&WML
Next Topic: Jinitiator and firewalls
Goto Forum:
  


Current Time: Thu Mar 28 19:26:09 CDT 2024