Re: Forms get Timestamp error when calling Stored procedure

yes:
  15.6 REQUIRED Schema Preparation for Pre-7.3.2 Database Versions

           If you are running a Developer/2000 Release 2.1 application

           against a pre-7.3.2 database that accesses stored program units,

           you must "synchronize" the environment that you deploy against

           with the environment you compiled against. When you are ready

           to deploy your application, you must prepare your schema with

           the steps listed below, then compile all your application

           modules. The compilation of your modules may be automated by

           using Project Builder. Then in the deployment environment, you

           can create the database schema in the normal manner, and then

           synchronize the schema with the same preparation steps listed

           below. Without these steps, you will see errors, warnings, or

           incorrect results from any module that uses stored program

           units. These steps MUST be repeated if any schema objects or

           any referenced schema object change.

           The PLX file referenced below can be found in the Extras

           directory on the installation CD. To prepare the schema, issue

           the following commands from Procedure Builder:

           PL/SQL> .disable compiler

           PL/SQL> .enable runtime

           PL/SQL> .attach lib sprep.plx

           Attaching library in file sprep.plx, BEFORE other attached

           libs..

           PL/SQL> .load prog schema_prep lib sprep

           Loading SCHEMA_PREP from library SPREP...

           PL/SQL> .execute prog schema_prep

           PL/SQL> .detach lib sprep

           PL/SQL> .disable runtime

           PL/SQL> .enable compiler

Heiki Hiisjarv schrieb:

> On Fri, 9 Apr 1999, Guenter Huerkamp wrote:
>
> > See the relnotes.txt in the orant\tools\doc20 directory. You must have
> > database 7.3.4 or
> > 8.0.4. In databases less you get timestamp problems.
> > Günter
>
> I have database 7.2.3 and getting this timestamp error. I have multiple
> databases:development database and production database, and I can't
> recompile against production database. Is there known solution for older
> database versions?
>
> Heiki Hiisja"rv
Received on Wed Apr 14 1999 - 19:56:10 CEST