PL/SQL error !

[Vysochin Artem]

good day.

please help , I am new in Oracle :

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

\
physical_addres s -- client ,
/

with the help of REF I established relation :

Master-block : client
Detail-block : physical_addres s
Object REF : fk_id_client (physical_addre ss 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_PHYSICALADDR ESS 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@astral.n tu-kpi.kiev.ua

[Jan]

Re: PL/SQL error !

Not working with Forms for last few years, but here are some general
good rules:

- put referential integrity into the database, not an application
- instead of using SQL for DML in the application, create stored
procedures in the database and call them from client. Then you can
put your business logic into them. They can be reused by other
applcations as well.

Jan



Vysochin Artem <webber@astral. ntu-kpi.kiev.uawrot e in message news:<cfdvak$2s u3$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_addres s -- client ,
/
>
with the help of REF I established relation :
>
Master-block : client
Detail-block : physical_addres s
Object REF : fk_id_client (physical_addre ss 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_PHYSICALADDR ESS 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@astral.n tu-kpi.kiev.ua