ORA-00933 in Entity Developer in LINQ mode

aram · Post by **aram** » Wed 03 Feb 2010 13:32

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

AndreyR · Post by **AndreyR** » Wed 03 Feb 2010 13:58

I have replied you in this post:
http://devart.com/forums/viewtopic.php?t=16637
Please let me know if something goes wrong.

AndreyR · Post by **AndreyR** » Wed 03 Feb 2010 14:50

Could you please provide us with the call stack of the exception?

aram · Post by **aram** » Wed 24 Feb 2010 09:05

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?

AndreyR · Post by **AndreyR** » Wed 24 Feb 2010 11:05

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.

aram · Post by **aram** » Wed 24 Feb 2010 12:03

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.

AndreyR · Post by **AndreyR** » Wed 24 Feb 2010 17:49

What is the full version of your Oracle server?

aram · Post by **aram** » Wed 24 Feb 2010 17:59

That I have to ask from the computer center.
I will let you know tomorrow during office ours.

Aram

aram · Post by **aram** » Sat 27 Feb 2010 11:51

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?

aram · Post by **aram** » Sat 27 Feb 2010 12:00

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,

AndreyR · Post by **AndreyR** » Mon 01 Mar 2010 09:26

Sorry, we don't have technical possibility to support LINQ to Oracle server versions prior to Oracle 9.2.

mplummer · Post by **mplummer** » Tue 21 Dec 2010 22:01

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).

AndreyR · Post by **AndreyR** » Thu 23 Dec 2010 16:33

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).

Devart Forums

ORA-00933 in Entity Developer in LINQ mode

ORA-00933 in Entity Developer in LINQ mode

This is very upsetting news