Re: FRM-40508 Error

OOPS
hit send too soon, that last bit should read:

 Begin
 insert into tabel (B1)
 (select tbl.aq from tbl where tbl.ew like :text_item16);  :system.message_level := 25;
 Commit;
 :system.message_level := 0;
 End;

(damn copy and paste!!!)

Eric C. Janzen <ejanzen_at_telusplanet.net> wrote in message news:UMv34.27075$n3.396469_at_news1.telusplanet.net...
> From the Developer Online Help:
>
> FRM-40508: ORACLE error: unable to INSERT record.
>
> Cause: A fatal error occurred while trying to insert a record. The table
> associated with the current block of the form might not exist, your
username
> might not have authority to perform the specified action on the table, or
> some other reason might have caused the fatal error.
>
> Action: Contact your DBA.
>
> Level: >25
>
> Type: Error
>
> When running the form and you get errors like this, go to the help menu
and
> click Display Error. It will tell you exactly what is wrong with the
> offending statement. Make it a habit to do that before anything else.
>
> In this case, you need brackets around a select statement used to insert
> values, like so:
>
> Begin
> insert into tabel (B1)
> (select tbl.aq from tbl where tbl.ew like :text_item16);
> Commit;
> End:
>
> Also, an inline commit here will give you the message "No changes to
save."
> You need to change the message level if you really want to do this. like
> so:
>
> Begin
> insert into tabel (B1)
> (select tbl.aq from tbl where tbl.ew like :text_item16);
> :system.message_level := 25;
> Commit;
> :system.message_level := 25;
> End;
>
>
> --
> --------------------------------------------------
> Eric Janzen
> E. Janzen Consulting Inc.
> Oracle Development Specialist
> --------------------------------------------------
>
>
>
>
>
> debbie <deb_at_freemail.com> wrote in message
> news:82l72q$l1g$1_at_news.net.uni-c.dk...
> > Hi
> >
> > I have made a PL/SQL trigger
> >
> > Begin
> > insert into tabel (B1)
> > select tbl.aq
> > from tbl
> > where tbl.ew like :text_item16;
> > Commit;
> > End:
> >
> > When I run the form the Error 40508 comes - what does that mean ?
> >
> >
> >
>
>
Received on Wed Dec 08 1999 - 17:36:20 CET