ORA-00933 in Entity Developer in LINQ mode

ORA-00933 in Entity Developer in LINQ mode

Postby 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
aram
 
Posts: 9
Joined: Wed 03 Feb 2010 12:34

Postby 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
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby AndreyR » Wed 03 Feb 2010 14:50

Could you please provide us with the call stack of the exception?
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby 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?
aram
 
Posts: 9
Joined: Wed 03 Feb 2010 12:34

Postby 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.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby 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.
aram
 
Posts: 9
Joined: Wed 03 Feb 2010 12:34

Postby AndreyR » Wed 24 Feb 2010 17:49

What is the full version of your Oracle server?
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby 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
 
Posts: 9
Joined: Wed 03 Feb 2010 12:34

Postby 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
 
Posts: 9
Joined: Wed 03 Feb 2010 12:34

Postby 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,
aram
 
Posts: 9
Joined: Wed 03 Feb 2010 12:34

Postby 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.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

This is very upsetting news

Postby 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).
mplummer
 
Posts: 1
Joined: Tue 21 Dec 2010 21:56

Postby 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).
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for Oracle