From: Carlos Diaz <crdiaz324@...>
Date: 2005-10-09T11:40:59+09:00
Subject: ruby9i bind_param errors

Hi,

I've been looking around and I just can't seem to find too much
documentation on ruby9i.  The only thing that I found gives a very
high-level explanation of how to use bind variables when talking to an
oracle 9i database.  Here is how they explain the bind_param method:

-----------------BEGIN QUOTE-------
Synopsis

statementObj.bind_param(label, bindvar)
Description

#bind_param binds bindvar to the parameter named label.

Bind variables are used for input of parameters in a DML statement or
for either input and output of parameters in a call to a stored
procedure or function.

---------------------END QUOTE--------------

Ok, so that seems pretty straight forward right?  Well here is my code:

---------------------BEGIN MY CODE--------------

stmt = dbh.prepare("select value from v$segment_statistics
        where statistic_name = :stat_name
        and object_name = :t_name
        and tablspace_name = :ts_name;")

    table_name = "SOME_TABLE"
    tablespace_name = "SOME_TABLESPACE"
    stmt.bind_param("stat_name", "db block changes")
    stmt.bind_pram("t_name", "#{table_name}")
    stmt.bind_param("ts_name", "#{tablespace_name}")
    stmt.execute
-------------------------END MY CODE-----------------

However, when I run this code snippet, I get an error saying that that
'bind_param' could not bind the varialbe in "stmt_bind_param".  Here
is an a copy of the error:

----------------BEGIN ERROR-----------------
in `bind_param': Could not bind variable in "stmt_bind_param" in file
"statement.c" at line 108 (Ruby9i::Error)
ORA-01036: illegal variable name/number
----------------END ERROR------------------

Anyone run into anything like this that would be able to point me in
the right direction?

Thanks in advance.
-Carlos