Oracle Stored Procedures - Out Vars

Discussion in 'Ruby' started by Vance Heron, Mar 26, 2006.

  1. Vance Heron

    Vance Heron Guest

    Can anyone help me with the syntax for retriving an 'out'
    variable from an Oracle Stored Procedure?

    I'm able to succesfully call several stored procedures,
    and can pass values in - both by putting the argument
    into the SQL statment, or by using a ? in the stmt
    then passing the value when I execute it, but have
    not been able to retrieve the 'out' value.

    I've tried sth.fetch()[0] ,and sth.get()

    Any help will be appreciated.

    Thanks,
    Vance
     
    Vance Heron, Mar 26, 2006
    #1
    1. Advertising

  2. Hi,

    Vance Heron <> writes:

    > Can anyone help me with the syntax for retriving an 'out'
    > variable from an Oracle Stored Procedure?
    >
    > I'm able to succesfully call several stored procedures,
    > and can pass values in - both by putting the argument
    > into the SQL statment, or by using a ? in the stmt
    > then passing the value when I execute it, but have
    > not been able to retrieve the 'out' value.
    >
    > I've tried sth.fetch()[0] ,and sth.get()


    ruby-dbi doesn't support out parameters.
    Use a driver specific function:
    sth.func:)bind_value, 0)

    --
    KUBO Takehiro
    email:
    web: http://www.jiubao.org
    GnuPG fingerprint = 5F7B C8EF CA16 57D0 FDE1 9F47 C001 1F93 AC08 2262
     
    KUBO Takehiro, Mar 28, 2006
    #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. Ricardo Magalhaes
    Replies:
    4
    Views:
    13,659
    Ricardo Magalhaes
    Jun 21, 2005
  2. Brew
    Replies:
    0
    Views:
    964
  3. Curtis
    Replies:
    4
    Views:
    14,876
    steve
    Jun 26, 2007
  4. sam944

    Oracle Stored Procedures

    sam944, Jun 23, 2006, in forum: Ruby
    Replies:
    7
    Views:
    295
    Jeffrey Hulten
    Jun 27, 2006
  5. RU
    Replies:
    2
    Views:
    243
Loading...

Share This Page