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_at_astral.ntu-kpi.kiev.ua> wrote in message news:<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 Thu Aug 12 2004 - 03:40:45 CDT