Re: ExecuteNonQuery returns ORA-01036 illegal variable name/number

Tech-Archive recommends: Fix windows errors by optimizing your registry

Jim Brandley wrote: 
I have used ExecuteNonQuery with no trouble for inserts, updates and
deletes. The best practices book I have says this is also the most efficient
way to return multiple column values from a single row. The requested fields
can be changed by users adding/removing fields from the form, so a stored
proc will not work - variable number of return values. I tried:
    Select name, rank into ( :V1, :V2 ) from mytable where keyvalue = :V3
and get ORA-01036. The bound parameters are named to match the sql
statement. IN params work fine, but I cannot make it happy with the OUT
params. Any help would be appreciated.



Just a thought - try the other provider for oracle (if you're using MS's , try using oracle's or vice versa).
.