Prev: tk scrollbar command
Next: Mac OS clipboard help
From: Amy on 2 Feb 2010 15:13
For some reason this code is failing with the error "not all variables
bound"

oraparse $cursor "UPDATE my_table SET col1=:col1, col2=:col2 where
my_dev = 'xyz'

orabindexec $cursor :col1 1 :col2 2

what am I doing wrong? Need help on this asap. It is so simple and
yet will not work!
From: Andreas Leitgeb on 2 Feb 2010 15:16
Amy <agrabham(a)globitech.com> wrote:
> For some reason this code is failing with the error "not all variables
> bound"
> oraparse $cursor "UPDATE my_table SET col1=:col1, col2=:col2 where
> my_dev = 'xyz'
> orabindexec $cursor :col1 1 :col2 2
> what am I doing wrong? Need help on this asap. It is so simple and
> yet will not work!

Just guessing: omit the colons:
orabindexec $cursor col1 1 col2 2

Did it work?
From: Andreas Leitgeb on 2 Feb 2010 15:21
Amy <agrabham(a)globitech.com> wrote:
> For some reason this code is failing with the error "not all variables
> bound"
> oraparse $cursor "UPDATE my_table SET col1=:col1, col2=:col2 where
> my_dev = 'xyz'
> orabindexec $cursor :col1 1 :col2 2
> what am I doing wrong? Need help on this asap. It is so simple and
> yet will not work!

Alternative blind guess: the double-quote in the oraparse line isn't
closed after 'xyz'.
From: Gerald W. Lester on 2 Feb 2010 17:32
Amy wrote:
> For some reason this code is failing with the error "not all variables
> bound"
>
> oraparse $cursor "UPDATE my_table SET col1=:col1, col2=:col2 where
> my_dev = 'xyz'


I assume that really is:

oraparse $cursor {
UPDATE my_table
SET col1 = :col1,
col2 = :col2
WHERE my_dev = 'xyz'
}

If not, then it should.

> orabindexec $cursor :col1 1 :col2 2
>
> what am I doing wrong? Need help on this asap. It is so simple and
> yet will not work!

That is what I see.


--
+------------------------------------------------------------------------+
| Gerald W. Lester |
|"The man who fights for his ideals is the man who is alive." - Cervantes|
+------------------------------------------------------------------------+
 | 
Pages: 1
Prev: tk scrollbar command
Next: Mac OS clipboard help