Re: Using dynamic PL/SQL in trigger.

Gary wrote:

> In my trigger, I have a code that generates a dynamic pl/sql block
> that contains the following:
>
> "begin if :new.test_column is null then raise column_is null; end if;
> end;"
>
> When I execute is code using the execute immediate command, I get an
> error because there is a bind variable expected.
>
> Is there anyway to escape the ':' character so that this code will
> execute like normal pl/sql?
>
> Thanks for any useful help.

Before reinventing the wheel one usually has pretty darned good reason. What's yours? Why are you recreating existing functionality?

Daniel Morgan Received on Fri Mar 07 2003 - 16:01:40 CST