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

By the way, this is failing as soon as it tries to bind the first param.

On 10/8/05, Carlos Diaz <crdiaz324@gmail.com> wrote:
> 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
>