dynamic block name
barisistJan 29 2013 — edited Jan 29 2013hi everybody
ı have two different database block, both have a column named SCL_DATE.
In pre-insert trigger of BLOCK1 I write sth like this : BLOCK1.SCL_DATE = SYSDATE;
And in pre-insert trigger of BLOCK2 I write sth like this : BLOCK2.SCL_DATE = SYSDATE;
But ı wonder if ı can write a procedure such as :SYSTEM.CURRENT_BLOCK.SCL_DATE = SYSDATE and can I use this procedure in pre-insert trigger of two blocks. I tried but this syntax didn't work.
I hope ı could make clear what ı mean. Sorry about my english. Thanks for any help...