Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: bind variable

Re: bind variable

From: steve <a_at_b.com>
Date: Thu, 5 Aug 2004 23:21:05 -0500
Message-ID: <10h61pfrn4fhk6e@corp.supernews.com>


| No version

oracle 9i release 9.0.1.0.0 - production

| No platform

jserver release 9.0.1.0.0 - production

| No operating system

red hat enterprise

| No code

"update foo set bar = bar + 1 where col1 = 'a' and col2 = 'b' returning bar into :foo_bar"

(select w/ same criteria returns only one record)

| No error message

sp2-0552: bind variable "foo_bar" not declared. Received on Thu Aug 05 2004 - 23:21:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US