Dear all,
Is it possible to execute a SP rather than an insert/update statement during write back in OBIEE ?
If it is possible, may I know the syntax ?
Thanks in advance
I don't think that is possible directly as the only tags in the XML writeback configuration are insert and update.
However, you could use a database trigger to call procedure on insert or update on your writeback table.
I would recommend writing back to a view, and using the learned gentleman's suggestion of putting a trigger on that to handle your logic, it is like building an API and putting the trigger on the view saves you from a host of convoluted logic to avoid mutating table issues - and you can point the data at multiple tables in a header / line / distribution type situation.
Though if you want fully formed form style functionality you would be better pointing the user at an Apex form.
