OBIEE Write back function - Execute Stored Procedure

User_RUIII

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

Joel

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.

Robert Angel

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.

Robert Angel

Though if you want fully formed form style functionality you would be better pointing the user at an Apex form.