Why do I error out when trying to retrieve a result set?

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
bclayshannon
Posts: 29
Joined: Wed 14 Mar 2012 18:37
Location: Monterey, California

Why do I error out when trying to retrieve a result set?

Post by bclayshannon » Wed 28 Mar 2012 21:31

With the code below I get, "ORA-01036: illegal variable name/number" on the call to ExecuteReader

Code: Select all

cmd.Parameters.Add("cur", Devart.Data.Oracle.OracleDbType.Cursor);
cmd.Parameters["cur"].Direction = ParameterDirection.Output;
Devart.Data.Oracle.OracleCursor oraCursor =
	(Devart.Data.Oracle.OracleCursor)cmd.Parameters["cur"].Value;
Devart.Data.Oracle.OracleDataReader odr = cmd.ExecuteReader();
while (odr.Read()) {
	ACurrentUserRoles.Add(odr.GetString(0));
}
This forum doesn't seem to be very busy, so I'm going to post this on stackOverflow, too.

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Post by Pinturiccio » Fri 30 Mar 2012 08:43

We have answered you at our forum http://www.devart.com/forums/viewtopic.php?t=23766

Post Reply