Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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;';
How do you think is this different from the OP's string?
Rene
>
> 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.
-- Projektleitung und Entwicklung in Oracle/C++/C# Projekten http://www.adp-gmbh.ch/cv.htmlReceived on Sat Mar 08 2003 - 05:20:47 CST