Re: Using dynamic PL/SQL in trigger.

On 7 Mar 2003 12:08:19 -0800, gary4work_at_hotmail.com (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.

Any reason why you can't use the ordinary NOT NULL check constraint? You are also obviously on your way to design a completely NON-SCALABLE application.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Mar 07 2003 - 15:36:19 CST