Re: Oracle Forms Compile error

The error is a Procedure Builder error - if you don't have access to Procedure Builder, its help file describes this as an error caused by an abnormal condition - which they then describe as either: "A bug in Developer/200 prevented the requested task from completing." or
"Someone did something that prevented Developer/2000 from completing the requested task. For example, if someone bypassed the user interface and changed data in one of the Developer/2000 tables, they may have typed in an invalid value."

First thing I'd try is incrementing the sequencer from the SQL/Plus command line, sounds like something may be messed up there. If that works????

In article <7u75qf$fem2_at_nntp.cig.mot.com>,   weiss_at_cig.mot.com (Phill Weiss) wrote:
>
> I am trying to compile a pre-insert trigger in Oracle forms 4.5
however, it
> will not compile. The text of my trigger is:
>
> declare temp number;
>
> begin
>
> select insp.seq_bsc_insp_id.nextval
> into temp from dual;
>
> :insp_master.insp_id := temp;
>
> end;
>
> "insp.seq.bsc_insp_id" is a sequence. When I compile the above, an
error dialog
> box pops up stating "PDE-PER001 internal error (deplu 3)." I've tried
to look
> up this error but can't find it. Has anyone ever seen this error
before. What
> does it mean, and how can I fix it? I would appreciate your help.
Thanks.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Oct 16 1999 - 00:47:27 CEST