Re: forms and reports problem across different Oracle version

Look at the Release notes for Developer 2.1:

"...
15.9 Limitations when Connected to a Pre-7.3.4 Database The following limitations only apply to pre-7.3.4 databases:

Problem 1 - PL/SQL Compilation performance may be poor. In some cases, the compilation may be greater than 10 times the normal compile time. Since PL/SQL compilation only occurs at design time, this is not a runtime issue.

Problem 2 - Connecting and disconnecting may take much longer than normal. In some cases it may take greater than 10 times the normal connect or disconnect time.

Problem 3 - When you compile PL/SQL, the schema name becomes bound into the PL/SQL code for client references to stored program units. The application can only be run against this schema. Against a 7.3.4 database the schema is resolved at runtime as in Developer/2000 release 1.x. The problem also exists in Oracle8 8.0.3, but is resolved with 8.0.4.

Problem 4 - To make sure that your PL/SQL code executes properly against a pre-7.3.2 database, you should refer to section 14.6 for information about preparing your database.

NOTE: Because of these problems we *strongly* recommend that you develop against an Oracle7 7.3.4+ or Oracle8 8.0.4+ database. We also *strongly* recommend that you deploy your applications against a 7.3.2 or higher database.
..."

I hope this will help you.

Brian Yan wrote:
>
> Hi there,
>
> Currently, we are developing some product using developer2000 2.1 over
> Oracle7.3.2. But the production is supposed to run on Oracle7.3.4. Does
> anyone know if there is any problem related to this case, i.e. some
> form/report works fine in Oracle7.3.2 but has problem on Oracle7.3.4? If
> yes, any patch available to avoid/fix it? Thank you for your help.
>
> Brian
 

-- 
Valery A. Sorokin
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoftmpc.msk.su
http://www.dd.ru