Parameter name starting with underscore

Parameter name starting with underscore

Postby alexB » Thu 29 Mar 2012 14:53

Hello,

I get the following exception when calling ExecuteReader() on an OracleCommand of CommandType.StoredProcedure and input parameter of type string and having the name "__myin":
Code: Select all
Devart.Data.Oracle.OracleException: ORA-06550: line 2, column 27:
PLS-00103: Encountered the symbol ":" when expecting one of the following:

   ( ) - + case mod new not null others <an identifier>
   <a double-quoted delimited-identifier> <a bind variable>
   table avg count current exists max min prior sql stddev sum
   variance execute multiset the both leading trailing forall
   merge year month DAY_ hour minute second timezone_hour
   timezone_minute timezone_region timezone_abbr time timestamp
   interval date
   <a string literal with character set specification>
   at Devart.Data.Oracle.t.d()
   at Devart.Data.Oracle.at.h()
   at Devart.Data.Oracle.at.c()
   at Devart.Data.Oracle.aa.a(Int32 A_0, bw A_1)
   at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
   at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
   at Devart.Data.Oracle.OracleCommand.ExecuteReader()


My Oracle: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
DotConnect version : 6.80.332

I am also sending you a test project that will help in reproducing the error.
alexB
 
Posts: 15
Joined: Fri 30 Apr 2010 11:06

Postby Shalex » Fri 30 Mar 2012 09:58

Please resend your test project again.
Shalex
Devart Team
 
Posts: 7602
Joined: Thu 14 Aug 2008 12:44

Postby alexB » Fri 30 Mar 2012 10:14

I just sent the test project again.
alexB
 
Posts: 15
Joined: Fri 30 Apr 2010 11:06

Postby Pinturiccio » Tue 03 Apr 2012 11:37

We have reproduced the issue. We will investigate it and notify you about the results as soon as possible.
Pinturiccio
Devart Team
 
Posts: 1950
Joined: Wed 02 Nov 2011 09:44

Postby Pinturiccio » Thu 05 Apr 2012 14:56

We are still investigating the issue. As a workaround, you can assign a value that does not begin with an underscore to the ParameterName property.
Pinturiccio
Devart Team
 
Posts: 1950
Joined: Wed 02 Nov 2011 09:44

Postby Pinturiccio » Mon 09 Apr 2012 13:27

We have implemented the support of any symbols in the OracleParameter.ParameterName property for the stored procedure. We will post here when the corresponding build of dotConnect for Oracle is available for download.
Pinturiccio
Devart Team
 
Posts: 1950
Joined: Wed 02 Nov 2011 09:44

Postby Pinturiccio » Fri 13 Apr 2012 08:05

The new build of dotConnect for Oracle 6.80.341 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=23886
Pinturiccio
Devart Team
 
Posts: 1950
Joined: Wed 02 Nov 2011 09:44

Postby alexB » Wed 18 Apr 2012 10:09

Works with the new build. Thank you.
alexB
 
Posts: 15
Joined: Fri 30 Apr 2010 11:06


Return to dotConnect for Oracle