Devart Forums

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,

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?

aram

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

Aram

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.

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?

aram

AndreyR wrote:Thank you for sharing your solution. The scenario with Primary Key is a default LINQ behaviour.

Thanks,
That is good to know.

Aram

aram

AndreyR wrote:Judging from your connection string in the other post, both problems can be associated with Unicode characters.
Please set the unicode connection string parameter to true.
Please let me know if this doesn't help.

Thank you for your reply,

I pressed the advanced button in the wizard of entity developer and selected the unicode.

I still get the ora-00933 error.

And about the read only error I was getting earlier. It seems you queries do not work if a table does not have a primary key.
So I set one of the fileds to primary key and it is performing the insert and update perfectly.

So for those of you who still get readonly error, if you can, make one of the fieds as primary key and see if it works.

Best Regards,
Aram

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

aram

AndreyR wrote:Could you please describe the problem?
What exception are you getting?
Could you please post a code sample you are using to modify data?

Hello, Since i have the same problem i will provide more details in this issue.

My code is:

Code: Select all

Bimstudentcontext.Bimstudentdatacontext context = new Bimstudentcontext.Bimstudentdatacontext();

Bimstudentcontext.Enumeration en=new Bimstudentcontext.Enumeration();
            en.Code = 10;
            en.En = "Test";
            en.Tr = "ıüğçöş"; // this is some unicode character
            context.Enumerations.InsertOnSubmit(en);
            context.SubmitChanges();

and the error i get on InsertOnSubmit line is
InvalidOperationException was unhandeled
Can't perform Create, Update or Delete operations on 'Table(Enumeration)' because it is read-only or does not have identity member.

and also when i try to update some record:

Code: Select all

 Bimstudentcontext.Bimstudentdatacontext context = new Bimstudentcontext.Bimstudentdatacontext();

            var enumerations = from v in context.Enumerations
                               where v.Code == 2
                               select v;
            foreach (var v in enumerations)
            {
                if (v.Code == 2)
                    v.Tr = "TESTING";
            }

            context.SubmitChanges();

it does not change the database.

I also get ORA-00933 twice on entity developer when using the database reverse engineering wizard.

My oracle version is: 8.1

Please help,
Thanks.

Devart Forums

Search found 9 matches

ORA-00933 in Entity Developer in LINQ mode