Re: FRM-40508 Error

[Quoted] 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 [Quoted] 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 [Quoted] 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." [Quoted] 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 ?

>

>

>