Aspx and datasource editor

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
sbslavonac
Posts: 35
Joined: Mon 02 Apr 2007 09:14

Aspx and datasource editor

Post by sbslavonac » Fri 08 May 2009 11:57

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

Shalex
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Tue 12 May 2009 15:52

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?

sbslavonac
Posts: 35
Joined: Mon 02 Apr 2007 09:14

Post by sbslavonac » Tue 12 May 2009 19:12

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

Shalex
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Thu 14 May 2009 09:56

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

Shalex
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Thu 14 May 2009 12:28

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.

Shalex
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 22 May 2009 15:55

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 .

Post Reply