Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Using dynamic PL/SQL in trigger.

Re: Using dynamic PL/SQL in trigger.

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 8 Mar 2003 11:20:47 GMT
Message-ID: <b4cjme$1uaqv7$1@ID-82536.news.dfncis.de>

> 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.html
Received on Sat Mar 08 2003 - 05:20:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US