Home » Developer & Programmer » Precompilers, OCI & OCCI » SELECT, IN bind, OUT bind
SELECT, IN bind, OUT bind [message #260890] Tue, 21 August 2007 03:42
Messages: 1
Registered: August 2007
Junior Member

my code example looks like this:


sqlStmt = string("SELECT id INTO ") + ":x" + " FROM table WHERE id=:1";
ResultSet *rs=stmt->executeQuery();
i = stmt->getUpdateCount();


Table has 10 rows, "index" has 10 elements (from 0 to 9), "id" goes from 0 to 9. When I execute this, I expect that all 10 rows are selected, but only first row is selected, for id=0.

When I use in WHERE clause instead of IN bind for example "A>20 and B<40" (A and B are columns in table) than I get more than one selected row (i>1).

Does anyone knows what is the problem?

P.S. I am using OCCI 9.2.
Previous Topic: Language C in oracle
Next Topic: Proc on Windows 2000
Goto Forum:

Current Time: Sun Jul 03 16:09:57 CDT 2022