Devart Forums

Hi,
I do not know if this is a bug or what but I have lost considerable amount of time with this.
Kept getting ORA-01008: not all variables bound in ds editor.

Created new datasource:
SELECT '1' UVJET, S.ID_HOTEL, R.ID_SOBA, A.ID AS ID_HOTEL_SOBA, R.ID_SOBA_USLUGA, S.ID_ARANZMAN, R.ID, R.DATUM_OD, R.DATUM_DO,
R.IZNOS_PERIOD, A.SOBA, G.OPIS AS USLUGA,
'BROJ OSOBA ' || A.OSOBA || DECODE (A.MAX_DODATNO, 0, '', '+(' || A.MAX_DODATNO || ')') AS MAX_OSOBA, R.LAST_MINUTE
FROM WEB_RASPOLOZIVO R,
WEB_SOBA_USLUGA G,
WEB_HOTEL_SOBA S,
WEB_SOBA A
WHERE R.ID_SOBA_USLUGA = G.ID
AND R.ID_SOBA = S.ID
AND S.ID_SOBA = A.ID
AND R.DATUM_OD IN (SELECT MIN (r.DATUM_OD)
FROM WEB_RASPOLOZIVO R
WHERE
(DATUM_OD = :DATUMOD) AND EXISTS (SELECT ID
FROM WEB_HOTEL_SOBA A WHERE A.ID_HOTEL = :IDHOTEL AND R.ID_SOBA = A.ID)

GROUP BY ID_SOBA)
AND R.DATUM_OD = :DATUMOD
AND EXISTS (SELECT ID FROM WEB_HOTEL_SOBA A WHERE A.ID_HOTEL = :IDHOTEL AND R.ID_SOBA = A.ID)

Lines marked red gave me trouble.
When I changed from

(DATUM_OD = :DATUMOD) AND EXISTS (SELECT ID
FROM WEB_HOTEL_SOBA A WHERE A.ID_HOTEL = :IDHOTEL AND R.ID_SOBA = A.ID)

to

(R.DATUM_DO>=:DATUMOD)
AND EXISTS (SELECT ID
FROM WEB_HOTEL_SOBA A WHERE A.ID_HOTEL = :IDHOTEL AND R.ID_SOBA = A.ID)
AND (r.DATUM_OD <= :DATUMOD)
Everything worked.
Any comments
Best regards
Boris

There was a bug in the 4.x versions of dotConnect for Oracle: the similar error arose if the same variable was used several times in the query in the direct mode. It is fixed in the latest versions. Please specify your current version, the mode (direct or not) you use. Does this problem persist with the latest 5.20.29 version of dotConnect for Oracle?

Sorry I forgot to mention :
Win XP
Visual studio 2008, sp1, net 3.5
5.20.29 dotnet
direct mode

It seems like the mentioned problem persists in the current build. I will notify you about the results of our investigation.

The issue with repeating parameters of OracleCommand in the Direct mode is fixed. Look forward to the next build of dotConnect for Oracle that will be available in a week.

The new build of dotConnect for Oracle 5.20.33 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=14909 .