Re: Stored Procedures & DB Triggers

Shlomo Rasnier <rasnier_at_wiztec.co.il> wrote:
>Hi there All,
>
>We are working with Oracle v7.1 and Designer 2000 v1.3
>
>Maybe some of you can advise me were in Designer 2000 Stored proc. and
>Data Base Trigger should be designed and written.
>
>All suggestions are welcomed.
>
>Thanks Shlomo.
>Email: Rasnier_at_wiztec.co.il

Hi there,

You can create stored procedure as

1. Create a new module.
2. In the properties window of the module, name the function as PL/SQL and Stored procedure. If you point to that field, there is a drop down list box available.

For creating triggers

1. Create a table.
2. Expand the table. You can find TRIGGERS.
3. Create a trigger and specify the firing event.

Regards

N.Prabhakar Received on Wed Nov 20 1996 - 00:00:00 CST