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
Aspx and datasource editor
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?
-
- Posts: 35
- Joined: Mon 02 Apr 2007 09:14
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 .
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 .