execute create trigger script in a procedure

Ludock · Oct 22, 2008 4:18AM

Is it possible to create a trigger with pl/sql?

I have made a procedure thats makes the create or replace trigger statement.
(when i copy and past the statement the trigger is created succesvol)

How can i execute the create trigger statement on the end of the procedure?

Thanks.

388131 · Oct 22, 2008 4:22AM

First of all I would reconsider if you really need to create a trigger inside a procedure. Question the reason...
Then, if you really need to do create it that way, you could try dynamic sql.

Ludock · Oct 22, 2008 4:25AM

This trigger have to be on all tables.

After creation a table, i call the procedure to generate the trigger.

388131 · Oct 22, 2008 4:29AM

Well, then proceed with dynamic SQL.

Or, in my opinion much better: produce a SQL script with variables for table name and trigger name.
Then run this script with the appropriate values every time you have created a table.

Cheers,
Guido

Edited by: Guido on Oct 22, 2008 10:30 AM

Forum Stats

Quick Links

Categories

execute create trigger script in a procedure

Answers

Data

Databases

Development

Development Tools

Open Source

Programs

Forum Stats

Categories

execute create trigger script in a procedure

Answers