connect oracle database

[Former Member]

Hi Expert,

I am new into VC. How to connect Oracle Database in VC for Insert,edit,delete

I have following requirements...

I have 2 input fields

1. Name

2 AGE

then 3 buttons

1. Insert

2. edit

3. delete

If click Insert button data will be stored in oracle database

if click edit button data will be edited in oracle database

if click delete button data will be deleted from the oracle database

please help...its very urgent..

Regards,

P.Manivannan.

[Former Member · Accepted solution]

Hi,

After configuring the BI JDBC system, you can select the system(which you have configured) in Find data and search for procedures for insertion, updation and deletion. Drag these to the iview.

Regards

Inder.

[Former Member · Accepted solution]

Hi,

Can u please tell me where will write the query?

Regards,

P.Manivannan.

[Former Member · Accepted solution]

If you can see the tables in the find data area after choosing your new system, then you drag and drop the table you want to the design board. The input port of the data service will hold a "SQL statement" field where you get to write your SQL.

Hint: don't give away all your points before getting a final solution to your problem.

Good Luck

Henning

[Former Member]

Hi,

Please follow this link which explains you the procedure to configure BI JDBC system for visual composer.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/6209b52e-0401-0010-6a9f-d40ec3a0...

Regards

Inder

Do reward points if helpful.