Hello,
I'm using Oracle Forms 10g and I have a PRE-INSERT-Trigger each on 7 structurally identical data blocks (block_1 ... block_7).
Each of these triggers does essentially the same, the only difference being the data block used.
I would like to write a procedure and pass the data block as a variable but I don't know
1) which data type to use
2) how to assign values to the fields of the data block or read their current values (e.g. block_1.field_1 := value)
I thought of passing the name of the data block as a string and then using GO_BLOCK( block_name ) and then querying the SYSTEM.CURSOR_BLOCK but then I still don't know how to address the fields.
Is there a way to accomplish that task nicely?
Any help is appreciated.
Thanks in advance.