Using quote delimiter in triggers
Hi,I'd like to use quote delimiter function in trigger,i.e. like
...
CASE WHEN inserting THEN
sql_str := ' insert into tablename(NAME) values ('|| :NEW.NAME||');'
..
but as taht :NEW varialbe might contain some special characters, it would be useful to use q'[ xxx ]' function introduced in 10g.
So next step is to modify trigger to be like
...
...
CASE WHEN inserting THEN
sql_str := ' insert into tablename(NAME) values ('|| q'[:NEW.NAME]'||');'
--> but now I'm capturing string :NEW.NAME isntead of the value in :NEW..NAME
...
I'm confused, is somebody brighter than me... please give a hand,
...
CASE WHEN inserting THEN
sql_str := ' insert into tablename(NAME) values ('|| :NEW.NAME||');'
..
but as taht :NEW varialbe might contain some special characters, it would be useful to use q'[ xxx ]' function introduced in 10g.
So next step is to modify trigger to be like
...
...
CASE WHEN inserting THEN
sql_str := ' insert into tablename(NAME) values ('|| q'[:NEW.NAME]'||');'
--> but now I'm capturing string :NEW.NAME isntead of the value in :NEW..NAME
...
I'm confused, is somebody brighter than me... please give a hand,
0