Re: FRM-40508 Error

From: <pberetta_at_my-deja.com>
Date: Thu, 09 Dec 1999 00:02:26 GMT
Message-ID: <82mrif$16r$1_at_nnrp1.deja.com>


Debbie,
  You need to qualify the variable as :YOUR_BLOCK_NAME.text_item16, the item name without the block name will not work. This error can also be caused by lack of privileges on the table, can you perform an insert into TABEL and select from TBL in SQL*Plus using the same User Name/Password/Host String combination? If not, fixing the variable will not solve the problem; you will need to be granted the necessary privileges to perform both these operations. Hope this helps,
Paul

In article <82l72q$l1g$1_at_news.net.uni-c.dk>,   "debbie" <deb_at_freemail.com> wrote:
> 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 ?
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 09 1999 - 01:02:26 CET

Original text of this message