Possible to insert, update, delete using BI JDBC?

[Former Member]

I am backporting VC models from 2004s to 2004. The only supported system to connect to an oracle db is the bi jdbc system in which I can't call stored procedures. Is it possible to do inserts, updates and deletes through VC SQL editor or otherwise?

Henning

[Former Member]

Please explain why "The only supported system to connect to an oracle db is the bi jdbc system ..."

[Former Member]

This relates to me having to backport the VC iviews to 2004. See how to document: <a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/bfe74c2e-0c01-0010-b99b-830ba6bb62e4">How to Transport Applications Modeled in Visual Composer from NetWeaver 2004s to NetWeaver 2004</a>

Henning

[Former Member]

Hi Henning,

Yes it is possible to do updates/inserts/etc throught the SQL Editor.

It should also be possible to execute stored procedures through BI JDBC, but you have to code it yourself (not drag and drop). Sample code below you could write in the SQL Editor (for Northwind DB on SQL server).

The limitation of backporting to NW2004 is limited to the SAP JDBC connector. The BI JDBC connector should be fine.

DECLARE @OrderID int

SET @OrderID = '10248'

EXEC [Northwind].[dbo].[CustOrderDetail] @OrderID

Cheers,

Ryan

[Former Member]

Please see the FAQ for Visual Composer

https://www.sdn.sap.com/irj/sdn/wiki

#26 Writing data back