PL/SQL error !

From: Vysochin Artem <webber_at_astral.ntu-kpi.kiev.ua>
Date: Wed, 11 Aug 2004 23:29:40 +0300
Message-ID: <cfdvak$2su3$1@news.ntu-kpi.kiev.ua>

good day.

please help , I am new in Oracle :

I use Oracle Forms 9i and want to create simple relation such as

                     \
    physical_address -- client ,

                     /

with the help of REF I established relation :

Master-block : client
Detail-block : physical_address
Object REF   : fk_id_client    (physical_address contains fk_id_client)

With property palette established REF Item            -- YES
for both data-blocks.
				  Enforce Primary Key -- YES 	

Then , apeared in the Object Navigator TRIGGERS (PRE-DELETE) , and one of them looks like this :

---

BEGIN
    DELETE FROM AT_PHYSICALADDRESS A
    WHERE A.FK_ID_CLIENT = (SELECT REF(A) FROM AT_CLIENT A WHERE rowid = :AT_CLIENT_DATA_BLOCK.rowid);
END;

---

  after compiling :

Error : 336,at line 4,column 16

        non-object-table "A" illegal in this context

Error : 0 , at line 2,column 4

        SQL statement ignored

WHY ?!
And in general : how to create CORRECT relation ?! help .

Thanks , webber_at_astral.ntu-kpi.kiev.ua Received on Wed Aug 11 2004 - 15:29:40 CDT