Executing an Oracle stored procedure

Discussion in 'Ruby' started by Daniel Berger, Jun 15, 2005.

  1. Hi all,

    Ruby 1.8.2
    OCI8

    I'm spacing - how do I call an Oracle stored procedure using DBI/OCI8?
    I tried a few things, but no luck.

    Thanks.

    Dan
     
    Daniel Berger, Jun 15, 2005
    #1
    1. Advertising

  2. Daniel Berger wrote:
    > Hi all,
    >
    > Ruby 1.8.2
    > OCI8
    >
    > I'm spacing - how do I call an Oracle stored procedure using DBI/OCI8?
    > I tried a few things, but no luck.
    >
    > Thanks.
    >
    > Dan


    Nevermind - got it.

    It's dbh.prepare("begin my_proc; end;")

    Don't forget that trailing semicolon.

    Regards,

    Dan
     
    Daniel Berger, Jun 15, 2005
    #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. raymond chiu
    Replies:
    1
    Views:
    5,699
    Tushar Agarwal
    Jan 21, 2006
  2. Sudhish K V

    Calling Oracle stored procedure using c#

    Sudhish K V, Nov 11, 2003, in forum: ASP .Net
    Replies:
    1
    Views:
    6,951
    David Browne
    Nov 11, 2003
  3. Peri
    Replies:
    1
    Views:
    401
    Patrick Olurotimi Ige
    Jun 13, 2005
  4. Mike P
    Replies:
    0
    Views:
    3,303
    Mike P
    Jun 19, 2006
  5. Replies:
    2
    Views:
    298
    bruce barker \(sqlwork.com\)
    Nov 8, 2006
Loading...

Share This Page