bind variables in OCI select

From: <mduval_at_aip.org>
Date: 1998/05/04
Message-ID: <6ikr9h$7if$1@nnrp1.dejanews.com>#1/1

Hello,

I'm trying to bind variables as part of an OCI select statement. I've tried using the same sql as I would in Pro*C. Here it is:

 select col1 into :COL1 from my_table

When I attempt this I get the error:

   obndra: ORA-01036: illegal variable name/number

Is there an OCI equivalent to this Pro*C SQL?

The Oracle servers tested with this were 7.1.6, 7.3.3 and 8.0.3.

Thanks in advance.

Mike Duval

---

Michael R. Duval

Senior Programmer/Analyst - Publishing Systems / Online Systems Section

---

American Institute of Physics                             mduval_at_aip.org

Woodbury, NY 11797-2999

Voice: 516-576-2368                                    FAX: 516-576-2615


========================================================================

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon May 04 1998 - 00:00:00 CDT