Page 1 of 1
ORA-00933 in Entity Developer in LINQ mode
Posted: Wed 03 Feb 2010 13:32
by aram
Hello,
I get ORA-00933 twice in entity developer, regarding the issue on
http://www.devart.com/forums/viewtopic.php?t=16637
Test Connection says sucessful, but when i press the next button in the wizard page, i get ORA-00933 twice.
This is my connection String:
user id=username;password=******;server=TG;connect mode=Default;home=orahome81;direct=False;persist security info=True
Posted: Wed 03 Feb 2010 13:58
by AndreyR
I have replied you in this post:
http://devart.com/forums/viewtopic.php?t=16637
Please let me know if something goes wrong.
Posted: Wed 03 Feb 2010 14:50
by AndreyR
Could you please provide us with the call stack of the exception?
Posted: Wed 24 Feb 2010 09:05
by aram
I didn't get an exception in entity developer. Just the error.
And I would like to mention that in Database Explorer of the entity developer, I am able to drag and drop the tables. But if I click on the '+' sign of procedures or functions or packages, I get the same error.
My client version is 8i and I won't be able to update it.
Could this problem happen when your software tries to extract the procedures?
Posted: Wed 24 Feb 2010 11:05
by AndreyR
The problem is likely to be associated with the Oracle client version.
Could you please try Direct mode?
The mentioned error should not be arised there.
Posted: Wed 24 Feb 2010 12:03
by aram
I did that.
Now clicking on the "+" signs other than the tables' gives the same error code ora-00933: SQL Command not properly ended.
However, the difference is:
My client was in turkish language, that's why it was giving the turkish version of ora-00933 message in orahome mode.
In direct mode I still get the same error, except the error is in English.
and why is it that I don't get the error for the tables?
Could it be that your pl/sql script needs ';' symbol on the end or a similar fact?
btw, I tried the given oracle provider by the client i installed, and i can access the procedures from within the server explorer in visual studio without a problem.
Posted: Wed 24 Feb 2010 17:49
by AndreyR
What is the full version of your Oracle server?
Posted: Wed 24 Feb 2010 17:59
by aram
That I have to ask from the computer center.
I will let you know tomorrow during office ours.
Aram
Posted: Sat 27 Feb 2010 11:51
by aram
AndreyR wrote:What is the full version of your Oracle server?
Hello, Unfortunately from Friday it was holiday here. Is there a way to know the version of oracle by writing a query or a similar thing using client?
Posted: Sat 27 Feb 2010 12:00
by aram
Ok, I used the query :
select * from v$version where banner like 'Oracle%'
to find the server version, if I'm not mistaken, it is:
Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production
Thanks,
Posted: Mon 01 Mar 2010 09:26
by AndreyR
Sorry, we don't have technical possibility to support LINQ to Oracle server versions prior to Oracle 9.2.
This is very upsetting news
Posted: Tue 21 Dec 2010 22:01
by mplummer
When I downloaded the trial beta version (6.0) I did get this error but it still executed the query set. Is there a possibility that there we be a release soon that will support it since I know that the beta version worked for it? I am in an environment where we don't currently have the ability to update our database version (extensive customization to the application).
Posted: Thu 23 Dec 2010 16:33
by AndreyR
We do not plan to add full support for Oracle versions prior to 9.2.0.4.
However, simple queries will work (provided there are no not supported elements like JOIN clauses).