Re: Using dynamic PL/SQL in trigger.

I too don't understand why you are doing this....but you can give the following a shot:

v_sqlString := 'BEGIN IF '||:NEW.TEST_COLUMN||' IS NULL THEN RAISE COLUMN_IS NULL; END IF;'; execute immediate v_sqlString;
-bhogak

Gary <gary4work_at_hotmail.com> wrote in message news:5128431b.0303071208.1add6299_at_posting.google.com...
> 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.
Received on Fri Mar 07 2003 - 21:13:29 CST