Parameter name starting with underscore

alexB · Post by **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.

Shalex · Post by **Shalex** » Fri 30 Mar 2012 09:58

Please resend your test project again.

alexB · Post by **alexB** » Fri 30 Mar 2012 10:14

I just sent the test project again.

Pinturiccio · Post by **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 · Post by **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 · Post by **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 · Post by **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

alexB · Post by **alexB** » Wed 18 Apr 2012 10:09

Works with the new build. Thank you.