ORA-00933: SQL command not properly ended

ORA-00933: SQL command not properly ended

Postby soldanoandrea » Wed 12 Feb 2014 10:55

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
 
Posts: 4
Joined: Wed 12 Feb 2014 10:50

Re: ORA-00933: SQL command not properly ended

Postby soldanoandrea » Wed 12 Feb 2014 14:13

Can someone try to help me ?

Otherwise I will go back and will not upgrade the solution ...
soldanoandrea
 
Posts: 4
Joined: Wed 12 Feb 2014 10:50

Re: ORA-00933: SQL command not properly ended

Postby soldanoandrea » Wed 12 Feb 2014 15:00

I managed it on my own.

Thanks for your prompt support and help. :evil: :evil: :evil: :shock: :shock: :shock:

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
soldanoandrea
 
Posts: 4
Joined: Wed 12 Feb 2014 10:50

Re: ORA-00933: SQL command not properly ended

Postby Shalex » Wed 12 Feb 2014 16:06

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/docs/?support.html) but we do our best to process the request as soon as possible.
Shalex
Devart Team
 
Posts: 7377
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle