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_at_news.ntu-kpi.kiev.ua>
good day.
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 :
Date: Wed, 11 Aug 2004 23:29:40 +0300
Message-ID: <cfdvak$2su3$1_at_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 - 22:29:40 CEST