URGENT: Oracle, EntityDAC and UniDAC

Discussion of open issues, suggestions and bugs regarding EntityDAC
Post Reply
claudio.piffer
Posts: 48
Joined: Mon 30 Apr 2007 07:36

URGENT: Oracle, EntityDAC and UniDAC

Post by claudio.piffer » Tue 05 Jan 2021 14:06

Hi,

I use last version of the EndityDAC and UniDAC in Delphi 10.4.1. I noticed that there is a different management on the generation of parameter names between a select and an update / insert.

In the gerenerated select statment the name of the parameters are :p0 - :p1 - :pn

while in the insert/update the name of the parameters are :paramNAME_OF_THE_ATTRIBUTE. This is a very big problem because the Oracle (11.0.2) raise an exception ORA-00972 identifier is too long because the name of the parameter exceeds 30 characters

This is a sample for the select statment:

Code: Select all

SELECT 
  t1.PERSONALE_FK PersonaleFk, 
  t1.REPARTI_FK RepartiFk, 
  t1.REPARTO_DEFAULT RepartoDefault, 
  t1.NOME_REPARTO NomeReparto, 
  t1.CODICE_OSPEDALE CodiceOspedale, 
  t1.NOME_OSPEDALE NomeOspedale, 
  t1.TIPO_REPARTO TipoReparto, 
  t1.PK_TIPO_WORKFLOW PkTipoWorkflow 
FROM 
  RISDBA.V_SWF_USER_WARDS t1 
WHERE 
  (t1.TIPO_REPARTO = :p0) AND 
  (t1.PERSONALE_FK = :p1)
This for an Update statment:

Code: Select all

update 
  RISENDO.CONFIGURAZIONE_REPARTO 
set 
  DICOM_MODE = :paramDicomMode, 
  LARGHEZZA_IMMAGINE = :paramLarghezzaImmagine, 
  INTGR_TRACCIAMENTO_ENDOSCOPI = :paramIntgrTracciamentoEndoscopi, 
  TIPOLOGIA_NOME_FOLDER_ESAME = :paramTipologiaNomeFolderEsame, 
  EXEC_ACQUISIZIONE_INFERMIERE = :paramExecAcquisizioneInfermiere 
where 
  PK_REPARTI_FK = :keyPkRepartiFk
Why are there these two different managements?

I am stuck on development and either find a solution very quickly otherwise I have to replace EntityDAC

I need urgent help!

Best Regards

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: URGENT: Oracle, EntityDAC and UniDAC

Post by MaximG » Wed 06 Jan 2021 17:00

We'll consider implementing the necessary changes in the near future. Please send us your license number. For your convenience, please use the e-support form https://www.devart.com/company/contactform.html

claudio.piffer
Posts: 48
Joined: Mon 30 Apr 2007 07:36

Re: URGENT: Oracle, EntityDAC and UniDAC

Post by claudio.piffer » Tue 19 Jan 2021 12:14

Hi Maxim,

any news?

Having purchased the source version I made some changes and they work but I would like to have an official solution.

Thank you very much

claudio.piffer
Posts: 48
Joined: Mon 30 Apr 2007 07:36

Re: URGENT: Oracle, EntityDAC and UniDAC

Post by claudio.piffer » Mon 01 Feb 2021 10:13

Any news?

Thank you very much

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: URGENT: Oracle, EntityDAC and UniDAC

Post by MaximG » Mon 01 Feb 2021 14:09

We will notify you about the results as soon as we receive them

claudio.piffer
Posts: 48
Joined: Mon 30 Apr 2007 07:36

Re: URGENT: Oracle, EntityDAC and UniDAC

Post by claudio.piffer » Fri 05 Mar 2021 08:14

Hi,

any news?

....more than a month has passed!

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: URGENT: Oracle, EntityDAC and UniDAC

Post by MaximG » Thu 11 Mar 2021 14:31

The issue turned out to be more complicated than we initially though. We need some more time.

addictedhungry
Posts: 1
Joined: Thu 14 Apr 2022 02:55

Re: URGENT: Oracle, EntityDAC and UniDAC

Post by addictedhungry » Thu 14 Apr 2022 02:56

Having purchased the source version I made some changes and they work but I would like to have an official solutionio games

Post Reply