Skip to Main Content

Could not using DB function call to insert a row into a table OBIEE

962844Oct 30 2012 — edited Nov 2 2012

In the prompt of OBIEE report, I create a DB function in one column variable of the prompt, so every time I go to the drop-down of the column variable OB call the DB function call.

The function call is insert a row into a table in the database. However, it seems cannot insert the row into table.

I test the function in the sqlplus and it works, so the function has no problem. The problem is OBIEE cannot insert something to the datebase, it can only read from it.

Any ideas about how could I solve it?