Hi,

I'm using LLBLGen Pro v. 2.6 (Sept. 12th) and ODP.NET 11g driver.

I get the error :

An exception was caught during the execution of a sequence retrieval query: ORA-00936: manglende udtryk. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception.

When I try to save an entity. The SQL executed looks like this :

    Query: INSERT INTO "HEST"."PAS$AKTIVITETER_T" ("AKTIVITET_ID", "DATABASE_ID", "PRIORITET_ID", "FORVENTET_AFSLUT_DATO", "TITEL", "AKTUEL_STATUS_ID", "VIA_ID", "AKTUEL_AKTIVITET_TYPE_ID", "PROJEKT_ID", "FORR_OMR_ID") VALUES (:AktivitetId1, :DatabaseId2, :PrioritetId3, :ForventetAfslutDato4, :Titel5, :AktuelStatusId6, :ViaId7, :AktuelAktivitetTypeId8, :ProjektId9, :ForrOmrId10)
    Parameter: :AktivitetId1 : Decimal. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: 33392.
    Parameter: :DatabaseId2 : Decimal. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: 3.
    Parameter: :PrioritetId3 : Decimal. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: 1.
    Parameter: :ForventetAfslutDato4 : Date. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: 13.10.2008 00:00:00.
    Parameter: :Titel5 : String. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: "adfafd".
    Parameter: :AktuelStatusId6 : Decimal. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: 0.
    Parameter: :ViaId7 : Decimal. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: 1.
    Parameter: :AktuelAktivitetTypeId8 : Decimal. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: 4.
    Parameter: :ProjektId9 : Decimal. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: 234.
    Parameter: :ForrOmrId10 : Decimal. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: 6.

If I take this SQL and execute it in SQLdeveloper I get the same error, unless I change the Parameter ForventetAfslutDato to 08-10-13 .

I thought this was the problem untill a few minutes ago, when I noticed the inner exception query executed was this :

"SELECT .NEXTVAL FROM DUAL"

I can't figure out where this last part comes from.

Thanks in advance

/Kasper

I figured out it was because I had set the ID field to be Identity / Sequence without setting the sequence to use. So I just unchecked the Identity / Sequence field.