Re: PL/SQL code vanish from triggers!!

Rein-Amund Schultz wrote:
>
> I have a problem:
>
> Sometime PL/SQL code seems vanish into thin air
> from triggers. This happens:
> I open the form in the designer, add some
> new triggers and code, compile - everything OK.
> When I generate I get the message:
> FRM-10093: No PL/SQL source code.
> This happens on all types of triggers,
> and in the amount of 1 to 3 triggers at the time.
>
> I use Forms Designer 4.5.6.3.3
> on a Compaq Deskpro 4000, Pentium Pro 180, 64 MB RAM,
> about 1 GB free on hard disk
> under WIN NT 3.51 (build 1057).
>
> If someone have experience with this problem I would
> appreciate that.
>
> Rein-A. Schultz
> reinas_at_hrp.no

[Quoted] [Quoted] I have had the same sort of problems with code in triggers disappearing. However, when it has happened to me Oracle gave me an error message when generating, stating something like

        Program Unit 32 Exists - Continue with creation ? Y/N It seems to me that Oracle gets messed up with the triggers and overwrites the previous ones, when you are creating a new one. It has only happened to me for forms which have heaps of code in the triggers. I do not have a solution other than try putting code into libraries and having the triggers calling a library module. This way you only lose the call to a library.

Sorry I could not help more

Regards
Raymond Boyd Received on Wed Dec 11 1996 - 00:00:00 CET