ORA-00933: SQL command not properly ended

[soldanoandrea]

Hi,
I have updated my software to Entity Framework 6.0.2 and to dotConnect for Oracle 8.2.90 Trial.

My software is not working anymore. I keep on getting the same Exception:
ORA-00933: SQL command not properly ended

This is the syntax pl/sql generated:

SELECT
"Project1".ID,
"Project1".ID_CV,
"Project1".CV_TYPE,
"Project1".NAME,
"Project1".SURNAME,
"Project1".GENDER,
"Project1".AGE_LESS,
"Project1".AGE_MORE,
"Project1".COMPANY_NAME,
"Project1".COD_NATIONALITY,
"Project1".BASED_IN_COUNTRY,
"Project1".BASED_IN_CITY,
"Project1".BASED_IN_RADIUS,
"Project1".OFFSHORE_EXP,
"Project1".AVAILABLE_FROM,
"Project1".AVAILABLE_UPTO,
"Project1".CV_LAST_MODIFIED_DATE_FROM,
"Project1".CV_LAST_MODIFIED_DATE_UPTO,
"Project1".PROPOSED_BY,
"Project1".CREATED_BY,
"Project1".CREATED_DATE,
"Project1".MODIFIED_BY,
"Project1".MODIFIED_DATE,
"Project1".LATITUDE,
"Project1".LONGITUDE,
"Project1".OPEN_POSITION
FROM ( SELECT
"Extent1".ID,
"Extent1".ID_CV,
"Extent1".CV_TYPE,
"Extent1".NAME,
"Extent1".SURNAME,
"Extent1".GENDER,
"Extent1".AGE_LESS,
"Extent1".AGE_MORE,
"Extent1".COMPANY_NAME,
"Extent1".COD_NATIONALITY,
"Extent1".BASED_IN_COUNTRY,
"Extent1".BASED_IN_CITY,
"Extent1".BASED_IN_RADIUS,
"Extent1".OFFSHORE_EXP,
"Extent1".AVAILABLE_FROM,
"Extent1".AVAILABLE_UPTO,
"Extent1".CV_LAST_MODIFIED_DATE_FROM,
"Extent1".CV_LAST_MODIFIED_DATE_UPTO,
"Extent1".PROPOSED_BY,
"Extent1".CREATED_BY,
"Extent1".CREATED_DATE,
"Extent1".MODIFIED_BY,
"Extent1".MODIFIED_DATE,
"Extent1".LATITUDE,
"Extent1".LONGITUDE,
"Extent1".OPEN_POSITION
FROM RIDY_CV.F_SEARCH_FILTER "Extent1"
WHERE "Extent1".CREATED_BY = :p__linq__0
) "Project1"
ORDER BY "Project1".ID DESC
OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY;

Can you please Help me ?


Andrea

[soldanoandrea]

Can someone try to help me ?

Otherwise I will go back and will not upgrade the solution ...

[soldanoandrea]

I managed it on my own.

Thanks for your prompt support and help.

The thing is that ProviderManifestToken has changed.
Now you have to specify something Oracle version (I think).
My edml schema was ProviderManifestToken="Oracle".
New version requires ProviderManifestToken="Oracle, 11.2.0.3"

Thanks,
bye
Andrea

[Shalex]

We are glad to hear that the issue is solved.

Our support has a two business days response policy (http://www.devart.com/dotconnect/oracle ... pport.html) but we do our best to process the request as soon as possible.