Skip to Content
avatar image
Former Member

connect oracle database

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 28, 2007 at 08:40 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • avatar image
    Former Member
    Nov 28, 2007 at 08:36 AM

    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-d40ec3a09424

    Regards

    Inder

    Do reward points if helpful.

    Add comment
    10|10000 characters needed characters exceeded