Toad World® Forums

Open package and update, alter object and commit, lost change in package


#1

this problem was caused with the following actions:

  1. open package ‘a’ and update its content (forgot to commit to db);
  2. alter an object ‘b’ (such as table) it was used in package ‘a’;
  3. during saving this object, all programs related to object ‘b’ were recompiled(include package ‘a’);
  4. all change in package ‘a’ was lost - crazy

this problem appears in 6.2.1 too. Sometime a dialog displays to let me choose ‘reload the package’ with yes or no. no matter what i chose, it must reload and lost all change.

i hope you can fix this problem as i was trapped many time carelessly.


#2

Hi Kent,

I tried your steps but in 3) the package was not recompiled or reloaded after I saved the procedure. I could just see the status of the package became invalid and I had to recompiled it manually and I didn’t lose the changes.

How did you save the object ‘b’ and did you perform any extra actions that might force to recompile and reload its dependants?

Thanks,
Vincent


#3

Sir,

Please set the related Preferences and try again.

regards,
Capture.jpeg


#4

Hi Kent,

Yes indeed, we have a problem here that must be fixed. It’s too late to include the fix into 6.3 as we are at the late stage of QA and this is not a regression, but it will be fixed after 6.3.

Regards,
Roman