The basic mono provider System.Data.OracleClient works fine. But when using Devart provider we get this error.
Code: Select all
NET: Unknown error 1
v Devart.Data.Oracle.p.b(Int32 A_0)
v Devart.Data.Oracle.p.a()
v xc.l.a(Byte A_0)
v xc.c.a(Byte A_0)
v xc.b.a()
v xc.a.a()
v xc.j.a()
v Devart.Data.Oracle.ad.a(ak A_0)
v Devart.Data.Oracle.t.a()
v Devart.Data.Oracle.ac.t()
v Devart.Data.Oracle.OracleDataReader.Close()
v E5.Data.SQLDataStoreBase.LoadData(DbCommand cmd) v
13.8.2009 9:19:13 - dvilimek
NET: Unknown error 1
v E5.Data.DataStore.Fill() v F:\e52\E5.Data\DS\DataStore.cs:řádek 326
v U5BankaFrontMPUTrm.Forms.KontrolniSestavy.UctovaniProduktuSheet..ctor()
INNER EXCEPTION
Vznikla chyba v databázi:
NET: Unknown error 1
v dotazu: SELECT DRU_BU.KOD, DRU_BU.POPIS, MENA.KOD, DRU_BU.JE_AKTIVNI, DIVIZE.KOD, POBOCKA.KOD, UCET_KTK_PODROZ.PREDCISLI, UCET_KTK_PODROZ.CISLO, UCET_KTK_PODROZ.NAZEV, UCET_KTK_PODROZM.KOD, UCET_BIL_PODROZ.PREDCISLI, UCET_BIL_PODROZ.CISLO, UCET_BIL_PODROZ.NAZEV, UCET_BIL_PODROZM.KOD, NULL, NULL, NULL, NULL, SA_KRED.KOD, SA_KRED.POPIS, SA_DEB.KOD, SA_DEB.POPIS, SA_NDEB.KOD, SA_NDEB.POPIS, NULL, NULL, UCET_CR_KRED.PREDCISLI, UCET_CR_KRED.CISLO, UCET_CR_KRED.NAZEV, UCET_CR_KREDM.KOD, UCET_UROK_KRED.PREDCISLI, UCET_UROK_KRED.CISLO, UCET_UROK_KRED.NAZEV, UCET_UROK_KREDM.KOD, UCET_DAN_UROK.PREDCISLI, UCET_DAN_UROK.CISLO, UCET_DAN_UROK.NAZEV, UCET_DAN_UROKM.KOD, UCET_CR_NDEB.PREDCISLI, UCET_CR_NDEB.CISLO, UCET_CR_NDEB.NAZEV, UCET_CR_NDEBM.KOD, UCET_UROK_NDEB.PREDCISLI, UCET_UROK_NDEB.CISLO, UCET_UROK_NDEB.NAZEV, UCET_UROK_NDEBM.KOD, UCET_CR_DEB.PREDCISLI, UCET_CR_DEB.CISLO, UCET_CR_DEB.NAZEV, UCET_CR_DEBM.KOD, UCET_UROK_DEB.PREDCISLI, UCET_UROK_DEB.CISLO, UCET_UROK_DEB.NAZEV, UCET_UROK_DEBM.KOD, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL FROM DRUH_BEZ_UCTU DRU_BU JOIN ((SELECT BUP.ID AS BUP_ID, BUP.DRUH_BEZ_ID AS BUP_DRUH_BEZ_ID, BUP.PLATI_OD AS BUP_PLATI_OD, BUP.PLATI_DO AS BUP_PLATI_DO, BUP.DZAZ AS BUP_DZAZ, BUP.UZI_ID AS BUP_UZI_ID, BUP.ZPUSOB_OBSLUHY_ID AS BUP_ZPUSOB_OBSLUHY_ID, BUP.TYP_UROCENI_ID AS BUP_TYP_UROCENI_ID, BUP.SAZBA_KREDIT_ZAKL_ID AS BUP_SAZBA_KREDIT_ZAKL_ID, BUP.TYP_UROKU_KREDIT AS BUP_TYP_UROKU_KREDIT, BUP.FREQ_UROCENI_KREDIT_ID AS BUP_FREQ_UROCENI_KREDIT_ID, BUP.DEN_UROCENI_KREDIT_ID AS BUP_DEN_UROCENI_KREDIT_ID, BUP.SAZBA_DEBET_ZAKL_ID AS BUP_SAZBA_DEBET_ZAKL_ID, BUP.TYP_UROKU_DEBET AS BUP_TYP_UROKU_DEBET, BUP.FREQ_UROCENI_DEBET_ID AS BUP_FREQ_UROCENI_DEBET_ID, BUP.DEN_UROCENI_DEBET_ID AS BUP_DEN_UROCENI_DEBET_ID, BUP.SAZBA_NDEBET_ZAKL_ID AS BUP_SAZBA_NDEBET_ZAKL_ID, BUP.TYP_UROKU_NDEBET AS BUP_TYP_UROKU_NDEBET, BUP.UCE_DAN_UROK_ID AS BUP_UCE_DAN_UROK_ID, BUP.UCE_CR_KRED_URO_ID AS BUP_UCE_CR_KRED_URO_ID, BUP.UCE_CR_DEB_URO_ID AS BUP_UCE_CR_DEB_URO_ID, BUP.UCE_CR_NDEB_URO_ID AS BUP_UCE_CR_NDEB_URO_ID, BUP.UCE_KRED_UROK_ID AS BUP_UCE_KRED_UROK_ID, BUP.UCE_DEB_UROK_ID AS BUP_UCE_DEB_UROK_ID, BUP.UCE_NDEB_UROK_ID AS BUP_UCE_NDEB_UROK_ID, BUP.PAR_DRU_ID AS BUP_PAR_DRU_ID, BUP.PAR_DRUH_SUBJEKTU_ID AS BUP_PAR_DRUH_SUBJEKTU_ID, BUP.POPIS AS BUP_POPIS, BUP.SAZBA_KREDIT_PROC_MIN AS BUP_SAZBA_KREDIT_PROC_MIN, BUP.SAZBA_KREDIT_PROC_MAX AS BUP_SAZBA_KREDIT_PROC_MAX, BUP.SAZBA_KREDIT_ODCHYLKA_MIN AS BUP_SAZBA_KREDIT_ODCHYLKA_MIN, BUP.SAZBA_KREDIT_ODCHYLKA_MAX AS BUP_SAZBA_KREDIT_ODCHYLKA_MAX, BUP.CASTKA_DEBET_MIN AS BUP_CASTKA_DEBET_MIN, BUP.CASTKA_DEBET_MAX AS BUP_CASTKA_DEBET_MAX, BUP.SAZBA_DEBET_PROC_MIN AS BUP_SAZBA_DEBET_PROC_MIN, BUP.SAZBA_DEBET_PROC_MAX AS BUP_SAZBA_DEBET_PROC_MAX, BUP.SAZBA_DEBET_ODCHYLKA_MIN AS BUP_SAZBA_DEBET_ODCHYLKA_MIN, BUP.SAZBA_DEBET_ODCHYLKA_MAX AS BUP_SAZBA_DEBET_ODCHYLKA_MAX, BUP.SAZBA_NDEBET_PROC_MIN AS BUP_SAZBA_NDEBET_PROC_MIN, BUP.SAZBA_NDEBET_PROC_MAX AS BUP_SAZBA_NDEBET_PROC_MAX, BUP.SAZBA_NDEBET_ODCHYLKA_MIN AS BUP_SAZBA_NDEBET_ODCHYLKA_MIN, BUP.SAZBA_NDEBET_ODCHYLKA_MAX AS BUP_SAZBA_NDEBET_ODCHYLKA_MAX, BUP.FREQ_VYPISU_ID AS BUP_FREQ_VYPISU_ID, BUP.KOD AS BUP_KOD, BUP.PAR_JE_REZIDENT AS BUP_PAR_JE_REZIDENT, BUP.U_UCET_KREDIT_ID AS BUP_U_UCET_KREDIT_ID, BUP.U_UCET_DEBET_ID AS BUP_U_UCET_DEBET_ID, BUP.U_UCET_NDEBET_ID AS BUP_U_UCET_NDEBET_ID, BUP.TYP_UCTU_ID AS BUP_TYP_UCTU_ID, BUP.SAZBA_DANE_ID AS BUP_SAZBA_DANE_ID, BUP.ZPUSOB_POPL_ID AS BUP_ZPUSOB_POPL_ID, BUP.SAZBA_KREDIT_PROC AS BUP_SAZBA_KREDIT_PROC, BUP.SAZBA_KREDIT_ODCHYLKA AS BUP_SAZBA_KREDIT_ODCHYLKA, BUP.CASTKA_DEBET AS BUP_CASTKA_DEBET, BUP.SAZBA_DEBET_PROC AS BUP_SAZBA_DEBET_PROC, BUP.SAZBA_DEBET_ODCHYLKA AS BUP_SAZBA_DEBET_ODCHYLKA, BUP.SAZBA_NDEBET_PROC AS BUP_SAZBA_NDEBET_PROC, BUP.SAZBA_NDEBET_ODCHYLKA AS BUP_SAZBA_NDEBET_ODCHYLKA, BUP.JE_DANENO AS BUP_JE_DANENO, BUP.PREF_MEN_ID AS BUP_PREF_MEN_ID, BUP.SKUP_PASEM_CIS_ID AS BUP_SKUP_PASEM_CIS_ID, BUP.UROK_SAZBA_TYP_ID AS BUP_UROK_SAZBA_TYP_ID, BUP.TYP_SAZBY_UROC_KREDIT_ID AS BUP_TYP_SAZBY_UROC_KREDIT_ID, BUP.TYP_SAZBY_UROC_DEBET_ID AS BUP_TYP_SAZBY_UROC_DEBET_ID, BUP.TYP_SAZBY_UROC_NDEBET_ID AS BUP_TYP_SAZBY_UROC_NDEBET_ID, BUP.DOBA_NEUROCENI_DEBET AS BUP_DOBA_NEUROCENI_DEBET, BUP.ZPU_UROCENI_DEBET_ID AS BUP_ZPU_UROCENI_DEBET_ID, BUP.DOBA_PLATNOSTI_KON_RAM AS BUP_DOBA_PLATNOSTI_KON_RAM, BUP.KTK_PODROZ_UCE_ID AS BUP_KTK_PODROZ_UCE_ID, BUP.BIL_PODROZ_UCE_ID AS BUP_BIL_PODROZ_UCE_ID, BUP.UCE_OPRAV_POL_ID AS BUP_UCE_OPRAV_POL_ID, BUP.UCE_TVORBA_POL_ID AS BUP_UCE_TVORBA_POL_ID, BUP.UCE_ROZPUST_POL_ID AS BUP_UCE_ROZPUST_POL_ID FROM BEZNY_UCET_PARAM BUP WHERE BUP.PLATI_DO IS NULL )) BUP ON ((BUP.BUP_DRUH_BEZ_ID = DRU_BU.ID)) LEFT OUTER JOIN MENA ON ((MENA.ID = BUP.BUP_PREF_MEN_ID)) LEFT OUTER JOIN POBOCKA ON ((POBOCKA.ID = DRU_BU.POBOCKA_ID)) LEFT OUTER JOIN DIVIZE ON ((POBOCKA.DIVIZE_ID = DIVIZE.ID)) LEFT OUTER JOIN UCET UCET_KTK_PODROZ ON ((UCET_KTK_PODROZ.ID = BUP.BUP_KTK_PODROZ_UCE_ID)) LEFT OUTER JOIN ((SELECT UM.ID AS UM_ID, UM.UCE_ID AS UM_UCE_ID, UM.MEN_ID AS UM_MEN_ID, UM.JE_PREFEROVANA AS UM_JE_PREFEROVANA FROM UCET_MENA UM WHERE (UM.JE_PREFEROVANA = 1) )) UMN ON ((UMN.UM_UCE_ID = UCET_KTK_PODROZ.ID)) LEFT OUTER JOIN MENA UCET_KTK_PODROZM ON ((UCET_KTK_PODROZM.ID = UMN.UM_MEN_ID)) LEFT OUTER JOIN UCET UCET_BIL_PODROZ ON ((UCET_BIL_PODROZ.ID = BUP.BUP_BIL_PODROZ_UCE_ID)) LEFT OUTER JOIN ((SELECT UM.ID AS UM_ID, UM.UCE_ID AS UM_UCE_ID, UM.MEN_ID AS UM_MEN_ID, UM.JE_PREFEROVANA AS UM_JE_PREFEROVANA FROM UCET_MENA UM WHERE (UM.JE_PREFEROVANA = 1) )) UMB ON ((UMN.UM_UCE_ID = UCET_BIL_PODROZ.ID)) LEFT OUTER JOIN MENA UCET_BIL_PODROZM ON ((UCET_BIL_PODROZM.ID = UMB.UM_MEN_ID)) LEFT OUTER JOIN U_UCET SA_KRED ON ((SA_KRED.ID = BUP.BUP_U_UCET_KREDIT_ID)) LEFT OUTER JOIN U_UCET SA_DEB ON ((SA_DEB.ID = BUP.BUP_U_UCET_DEBET_ID)) LEFT OUTER JOIN U_UCET SA_NDEB ON ((SA_NDEB.ID = BUP.BUP_U_UCET_NDEBET_ID)) LEFT OUTER JOIN UCET UCET_CR_KRED ON ((UCET_CR_KRED.ID = BUP.BUP_UCE_CR_KRED_URO_ID)) LEFT OUTER JOIN ((SELECT UM.ID AS UM_ID, UM.UCE_ID AS UM_UCE_ID, UM.MEN_ID AS UM_MEN_ID, UM.JE_PREFEROVANA AS UM_JE_PREFEROVANA FROM UCET_MENA UM WHERE (UM.JE_PREFEROVANA = 1) )) UMCRK ON ((UMCRK.UM_UCE_ID = UCET_CR_KRED.ID)) LEFT OUTER JOIN MENA UCET_CR_KREDM ON ((UCET_CR_KREDM.ID = UMCRK.UM_MEN_ID)) LEFT OUTER JOIN UCET UCET_UROK_KRED ON ((UCET_UROK_KRED.ID = BUP.BUP_UCE_KRED_UROK_ID)) LEFT OUTER JOIN ((SELECT UM.ID AS UM_ID, UM.UCE_ID AS UM_UCE_ID, UM.MEN_ID AS UM_MEN_ID, UM.JE_PREFEROVANA AS UM_JE_PREFEROVANA FROM UCET_MENA UM WHERE (UM.JE_PREFEROVANA = 1) )) UMNK ON ((UMNK.UM_UCE_ID = UCET_UROK_KRED.ID)) LEFT OUTER JOIN MENA UCET_UROK_KREDM ON ((UCET_UROK_KREDM.ID = UMNK.UM_MEN_ID)) LEFT OUTER JOIN UCET UCET_DAN_UROK ON ((UCET_DAN_UROK.ID = BUP.BUP_UCE_DAN_UROK_ID)) LEFT OUTER JOIN ((SELECT UM.ID AS UM_ID, UM.UCE_ID AS UM_UCE_ID, UM.MEN_ID AS UM_MEN_ID, UM.JE_PREFEROVANA AS UM_JE_PREFEROVANA FROM UCET_MENA UM WHERE (UM.JE_PREFEROVANA = 1) )) UMKD ON ((UMKD.UM_UCE_ID = UCET_DAN_UROK.ID)) LEFT OUTER JOIN MENA UCET_DAN_UROKM ON ((UCET_DAN_UROKM.ID = UMKD.UM_MEN_ID)) LEFT OUTER JOIN UCET UCET_CR_NDEB ON ((UCET_CR_NDEB.ID = BUP.BUP_UCE_CR_NDEB_URO_ID)) LEFT OUTER JOIN ((SELECT UM.ID AS UM_ID, UM.UCE_ID AS UM_UCE_ID, UM.MEN_ID AS UM_MEN_ID, UM.JE_PREFEROVANA AS UM_JE_PREFEROVANA FROM UCET_MENA UM WHERE (UM.JE_PREFEROVANA = 1) )) UMCRND ON ((UMCRND.UM_UCE_ID = UCET_CR_NDEB.ID)) LEFT OUTER JOIN MENA UCET_CR_NDEBM ON ((UCET_CR_NDEBM.ID = UMCRND.UM_MEN_ID)) LEFT OUTER JOIN UCET UCET_UROK_NDEB ON ((UCET_UROK_NDEB.ID = BUP.BUP_UCE_NDEB_UROK_ID)) LEFT OUTER JOIN ((SELECT UM.ID AS UM_ID, UM.UCE_ID AS UM_UCE_ID, UM.MEN_ID AS UM_MEN_ID, UM.JE_PREFEROVANA AS UM_JE_PREFEROVANA FROM UCET_MENA UM WHERE (UM.JE_PREFEROVANA = 1) )) UMNND ON ((UMNND.UM_UCE_ID = UCET_UROK_NDEB.ID)) LEFT OUTER JOIN MENA UCET_UROK_NDEBM ON ((UCET_UROK_NDEBM.ID = UMNND.UM_MEN_ID)) LEFT OUTER JOIN UCET UCET_CR_DEB ON ((UCET_CR_DEB.ID = BUP.BUP_UCE_CR_DEB_URO_ID)) LEFT OUTER JOIN ((SELECT UM.ID AS UM_ID, UM.UCE_ID AS UM_UCE_ID, UM.MEN_ID AS UM_MEN_ID, UM.JE_PREFEROVANA AS UM_JE_PREFEROVANA FROM UCET_MENA UM WHERE (UM.JE_PREFEROVANA = 1) )) UMCRD ON ((UMCRD.UM_UCE_ID = UCET_CR_DEB.ID)) LEFT OUTER JOIN MENA UCET_CR_DEBM ON ((UCET_CR_DEBM.ID = UMCRD.UM_MEN_ID)) LEFT OUTER JOIN UCET UCET_UROK_DEB ON ((UCET_UROK_DEB.ID = BUP.BUP_UCE_DEB_UROK_ID)) LEFT OUTER JOIN ((SELECT UM.ID AS UM_ID, UM.UCE_ID AS UM_UCE_ID, UM.MEN_ID AS UM_MEN_ID, UM.JE_PREFEROVANA AS UM_JE_PREFEROVANA FROM UCET_MENA UM WHERE (UM.JE_PREFEROVANA = 1) )) UMND ON ((UMND.UM_UCE_ID = UCET_UROK_DEB.ID)) LEFT OUTER JOIN MENA UCET_UROK_DEBM ON ((UCET_UROK_DEBM.ID = UMND.UM_MEN_ID))