Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on 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 a 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

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.