OBIEE 11g writeback insert records
Hi all,
Has anyone been able to insert records using writeback in 11g?
Update works, in 10g if there was a null record in the table and we update that record it would insert the data i believe.
Same approach doesn't work in 11g, it doesn't error out but it doesn't update the DB table either.
XML used:
<?xml version="1.0" encoding="utf-8" ?>
<WebMessageTables xmlns:sawm="com.siebel.analytics.web/message/v1">
<WebMessageTable lang="en-us" system="WriteBack" table="Messages">
<WebMessage name="TableGrid">
<XML>
<writeBack connectionPool="Oracle Data Warehouse Connection Pool">
*<insert> INSERT into TABLE1 values('@{c9f3da4f42c98e424}','@{cd45562e7d016c27f}','@{c00248ca99fa792a5}','@{c9c914b3cedd792cd}','@{cab7c9ca342251a00}') </insert>*
<update>UPDATE TABLE1 SET RPD_GROUPS='@{c9c914b3cedd792cd}' WHERE LOGON_NAME='@{c9f3da4f42c98e424}'</update>
</writeBack>
</XML>
</WebMessage>
</WebMessageTable>
</WebMessageTables>
There are no logs generated ofcourse, so at this point not sure whats missing, i don't see an insert button either.
Thanks
Edited by: 884097 on Sep 12, 2011 12:15 PM