Devart Forums

Dominik

Hi,

We have upgrade our Devart dotConnect for Oracle version from 5.70.190 to 8.1.45 regarding a problem with framework .NET 4.5.

Now we have installed the new Devart product in our development environment, but we also have old versions of our product projects referencing v5.70 libraries. So in this case, when we run an older project we get this error at execution time:

MissingMethodException - Method not found: 'Void Devart.Data.Oracle.Entity.OracleEntityProviderServices.set_TypedNulls(Boolean)'.

Is there any way to solve this problem?

Thanks in advance,

Dominik.

Dominik

Hi,

Does Devart Oracle data provider support this functionality?

http://www.albahari.com/nutshell/linqkit.aspx

Thanks in advance,

Dominik.

Dominik

Sorry, it works!

It was my fault. The previous function definition in Oracle was a test. The real stored procedure is defined as follows:

Code: Select all

CREATE OR REPLACE PROCEDURE "OBTENER_ARBOLPERFIL" (
  IdPerfil IN NUMBER,
  Productos         IN VARCHAR2,
  ASeguridad_Out OUT SYS_REFCURSOR) IS
BEGIN
  OPEN ASeguridad_Out FOR
  SELECT AP_CI, AP_CS_CI, AP_MSC, AP_RNG, AP_PROD
  FROM TABLE(Arbolperfil(IdPerfil, Productos))
  WHERE AP_MSC IS NOT NULL;
END OBTENER_ARBOLPERFIL;

And now, it works ok.

Thank you very much,

Dominik.

Dominik

Still have the same problem:

{"ORA-06550: line 2, column 3:\nPLS-00306: wrong number or types of arguments in call to 'OBTENER_ARBOLPERFIL'\nORA-06550: line 2, column 3:\nPL/SQL: Statement ignored"}

SQL SERVER:

Code: Select all

CREATE  procedure [dbo].[OBTENER_ARBOLPERFIL]
(
  @IdPerfil INT, 
  @Productos varchar(20)
)
AS 
begin

SELECT AP_CI, AP_CS_CI, AP_MSC, AP_RNG, AP_PROD
FROM Arbolperfil(@IdPerfil, @Productos)
WHERE AP_MSC IS NOT NULL

END

Code: Select all

ORACLE:

Code: Select all

CREATE OR REPLACE FUNCTION "OBTENER_ARBOLPERFIL" (

  IdPerfil IN NUMBER,
  Productos         IN VARCHAR2
) RETURN SYS_REFCURSOR IS
  ASeguridad_Out SYS_REFCURSOR;
BEGIN
  OPEN ASeguridad_Out FOR
  SELECT AP_CI, AP_CS_CI, AP_MSC, AP_RNG, AP_PROD
  FROM TABLE(Arbolperfil(IdPerfil, Productos))
  WHERE AP_MSC IS NOT NULL;
END OBTENER_ARBOLPERFIL;

Code: Select all

Dominik

Hi,

In our project we must to deal with Oracle and SQL Server models. For a concrete query we need to create a Function or Stored Procedure in order to get a list of values according to several specified parameters.

In our Oralce database we return an Output parameter to get a select result, but this parameter is it not required in SQL Server, so the number of parameters differ in both models.

How could we solve this problem? Is it possible to get the same number of parameters in both databases?

Any advice in this regard will be welcome.

Thanks in advance,

Dominik.

Dominik

Ok,

At the moment I try to add "Current Language=us_english" to my Sql connection string and it sets the language option at Login.

But how can I set this Session Parameters for Oracle?

ALTER SESSION SET NLS_COMP=ANSI

ALTER SESSION SET NLS_SORT=SPANISH

I don't know what keyword values I must use in the connection string...

Thanks in advance,

Dominik.

Dominik

Thank you very much.

But I must deal with SQL Server databases also, so with this solution I should create a factory or some other solution.

Do you think I could be able to set these vaules using Language keyword in my connection strings? They are different for SQL Server and Oracle...

Thanks again,

Dominik.

Dominik

Hi,

We need to establish Session Parameters to Oracle databases for example:

ALTER SESSION SET NLS_COMP=ANSI

ALTER SESSION SET NLS_SORT=SPANISH

How could this be done?

In addition, we need to deal with SQL Server databases, so we need to establish also SET Options like:

SET LANGUAGE SPANISH

Must we need to build a factory pattern in this case or can EF establish Session Parameters or SET Options?

Thanks in advance,

Dominik.

Dominik

Hi,

Is there any way to get ROWNUM and add it to my EDMX entity model as a property field using IQueryable sentences?

Thanks in advance,

Dominik.

Dominik

Hi again,

I'm trying to perform tracing with DBMonitor tool in this way:

#if TRACING
// Oracle Trace with DBMonitor
Devart.Data.Oracle.OracleMonitor mon = new Devart.Data.Oracle.OracleMonitor() { IsActive = true };
#endif

But instead of include a preprocessor directive, data is always visible at DBMonitor.

Is that normal?

Dominik

Hi,

I don't know if I understand it at all. My Oracle database is already created, but I need to create EDMX models for both environments.

I copied my original SQL Server model, and then changed the DDL Generation Template property to "Devart SSDLToOracle.tt".

This would change the SSDL types to their corresponding in Oracle, or may I change them manually?

I would like to have some automatic mode to work with both SQL Server and Oracle databases, and avoid manual changes as much as possible.

Thanks,

Dominik.

Dominik

Hi,

In my edml model, If I declare an entity field as Store Generated Pattern=Identity, this is translated to my CDSL content as an attribute annotation:StoreGeneratedPattern="Identity" in field property.

Then, if I try to create a new entity to my Oracle database, I get this error:

System.Data.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Devart.Data.Oracle.OracleException: ORA-00001: unique constraint violated.

If I add manually the attribute StoreGeneratedPattern="Identity" to my SSDL content as an attribute of the field property as in my EDMX model for SQL Server, then it works without any problem.

Was that a bug in edml model?

Thanks in advance,

Dominik.

Dominik

Hi,

Thank you very much for this information about using EDM wizard with dotConnect for Oracle, I will try it as soon as I have some free time.

Respect to my problems with Table Per Hierarchy Inheritance model, I could finally solve it playing a little bit with database types and perform some manually changes at edml schema, but I do not know exactly which of my changes made it work.

Thanks again,

Dominik.

Dominik

Hi,

According to your sample project, can I work with DevArt provider using an EDMX data model?

By the moment, I was using DevArt entity model dessigner. As I'm working also with SQL Server databases, could be better to work both database models with ADO.NET Entity Data Model? or is it not relevant?

Thanks,

Dominik.

Dominik

Hi again,

I was able to get it working adding Oracle ssdl as a embedded recource and sharing csdl and msl schemas generated by SQL Server.

But in any case, I prefer to use full Oracle content schemas.

How can I know what is wrong with my Oracle edml model?

Thanks,

Dominik.

Devart Forums

Search found 29 matches

Versions backward compatibility in development environment

LINQKit

Wrong number or types of arguments in call to PROCEDURE

Session Parameters

Get ROWNUM

StoreGeneratedPattern="Identity"