Re: HELP!!!

In article <7rae81$t9p$1_at_nnrp1.deja.com>,   rgoyal_at_techbooks.com wrote:
> I am facing a unique problem.I am using Oracle 8.0.4 Database with
> Developer 2000 Ver 2.0 as front end..Any time I undertake Database
> related
> activities like Dropping or Truncating Tables and repopulating them
from
> a backup all my Application's generated report executables ie .rep
> files stop working .The error code is REP -0001.Hence we have to
> regenerate the executables from their source codes ie .RDF files
> to make them work.
> This has come up many times.Is it a program bug or Something Else
> Please help me out with a fast solution to the same
> Thanks
>

I am not very familiar with compiled developer 2000 reports but I have some suggestions that may help.

If you have pl/sql inside your report writer reports or are using packages this may have to be recompiled in order to respond to a drop table create table sequence.

Sometimes when I am using developer 2000 in interactive mode, changes made to tables or new tables will can not be seen by developer 2000, before i reconnect to the database.

I'am surprised that the error also occurs when you just truncate a table. It does seem plausible though, that the drop or create table will invalidate your reports.

Hope the above suggestions can help

> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Sep 10 1999 - 06:16:22 CDT