How do I call an Oracle procedure from a VS 2005 ObjectDataSource?

Discussion in 'ASP .Net' started by Steve Kershaw, Sep 10, 2007.

  1. Hi,

    I need to call an Oracle procedure from an ObjectDataSource so I can
    "Commit" the changes to the database. While using a TableAdapter is
    great for retrieveing data (select * from mytable) for example, but
    updating and inserting into an oracle table is difficult in a
    TableAdapter because of the requirement to Commit; the changes and
    TableAdapters will only compile SQL (versus PL/SQL) commands.

    Can anybody help me in this?

    Thanks so much
    Steve
    Steve Kershaw, Sep 10, 2007
    #1
    1. Advertising

  2. On Sep 10, 11:40 am, Steve Kershaw <> wrote:
    > Hi,
    >
    > I need to call an Oracle procedure from an ObjectDataSource so I can
    > "Commit" the changes to the database. While using a TableAdapter is
    > great for retrieveing data (select * from mytable) for example, but
    > updating and inserting into an oracle table is difficult in a
    > TableAdapter because of the requirement to Commit; the changes and
    > TableAdapters will only compile SQL (versus PL/SQL) commands.
    >
    > Can anybody help me in this?
    >
    > Thanks so much
    > Steve


    Did I use a bad word "Oracle"?! :)

    Common people! You are the experts and you have helped me out many
    times before! Now it seems that nobody knows anything about VS 2005 -
    Oracle?!

    Thanks

    Steve
    Steve Kershaw, Sep 10, 2007
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Mike P
    Replies:
    0
    Views:
    3,299
    Mike P
    Jun 19, 2006
  2. Steve Kershaw
    Replies:
    0
    Views:
    415
    Steve Kershaw
    Aug 21, 2007
  3. AlexWare
    Replies:
    2
    Views:
    756
    Paul Uiterlinden
    Oct 23, 2009
  4. David Thielen

    ObjectDataSource method as another ObjectDataSource

    David Thielen, Mar 21, 2006, in forum: ASP .Net Web Controls
    Replies:
    3
    Views:
    242
    Steven Cheng[MSFT]
    Mar 23, 2006
  5. Feyruz
    Replies:
    4
    Views:
    2,161
    Sherm Pendley
    Oct 14, 2005
Loading...

Share This Page