Re: PL/SQL question

If you want to use variable column names in your procedure, you would have to use dynamic sql.

Another possibility is to _generate_ the trigger. This should not be to difficult. ( A script containing desc TABLENAME to file, followed by some awk/sh statement to generate the TRIGGER.SQL file)

The drawback with this solution is that you would have rekompile the trigger if you are making changes to the table.

regards, Bo.

        _________|                                |_________
        \        |         Bo Bell                |        /
         \       |    Bergen Data Consulting a/s  |       /
          \      |  5049 Sandsli, Bergen, Norway  |      /
	  /      |  e-mail: bob_at_ddb.be.statoil.no |      \
         /       |________________________________|       \
        /___________)                          (___________\